EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Excel Sort by color
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Excel Sort by color

By Karthikeyan SubburamanKarthikeyan Subburaman

Sort by color in exel

Sort by color in Excel (Table of Contents)

  • Sort by color in Excel
  • How to Use Sorting In Excel?
  • Examples of Sort by color in Excel

Sort by color in Excel

In Excel, there are two ways to sort any data by Color. Firstly, we can sort the data by color through filters. For this, apply the filter selecting an option from the Data menu tab and then select the Sort by cell color or font color from the drop-down option. And other ways is sorting the data using the Sort option available in the Data menu tab. Once we select this, under Sort On the drop-down, we can select the sorting by cell color or by font color.

How to Use Sorting In Excel?

In excel, we can find SORT under the DATA menu, as shown in the below screenshot.

Sort by color in Excel 1

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

We can sort the data by color in excel in a simple way where we have a custom sort option in excel, here we can sort the data by multiple options like by Cell Color or by Value (Numbers) or by Font Color or by Cell Icon or by ascending or descending order. Once we click on the sort option, we will get the below dialogue box with multiple sorting as shown below.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,596 ratings)

Sort by color in Excel 2

Examples of Sort by color in Excel

In this example, we are going to see how to sort the data by color.

You can download this Sort by color Excel Template here – Sort by color Excel Template

Example #1: Sort By Cell Color

let’s consider the sales data, which has several categories like product name, Brand, MRP, Selling Price, Local, Zonal, National.

In sales data, we have categorized brands in specific colors so that they can be displayed easily, as shown in the below screenshot.

Example 1

To apply sort by color in the sales data, follow the below steps.

  • Select the C column named as Brand.

Column Brand 1.1

  • Go to Data Menu and click Sort.

Sort by color in Excel 1

  • Once we click the sort, the sorting feature will either expand the selection or ask the option, so select Expand the selection and click the Sort command button so that we will get multiple sorting options, as shown below.

Select Expand the selection 1.3

  • We can see that sort by has various options that come from the sales data caption header like Brand, MRP, SP, Local, Zonal, National, Year.

Sort by color in example 1.4

  • Now let’s select sort by “Brand”, Select Sort on by Cell Color, so that we can sort the Brand by color.

Sort by color in example 1.5

  • Now select the order by color where the sorting option will show various colors that we have already mentioned for all brands. Hence we can select any color, so I have selected a purple color.

Sort by color in example 1.6

  • Here the color purple represents the Brand name “Kare In”, so the brand will be sorted color-wise as shown below and select the option on top so that sorting will get the order by chosen color on top.
  • Sort by color in example 1.7

Example #2: Sort by Font Color

In this example, we will see how to do sorting by font color by using the same sales data where MRP has been highlighted as a specific colour that denotes highest to lowest MRP.

Example 2.1

In the above sales data, we can see that MRP has been highlighted by font color, and we will do the sorting by font color as follows.

  • Select the cell name MRP.

Sort by color in example 2.2

  • Go to the Data menu and click Sort.

Sort by color in Excel 1

  • Once we click Sort, the sorting feature will either expand the selection or ask the option as shown below. Choose ‘ Expand the selection ‘ and click the Sort command button.

Sort by color in example 2.3

  • We will get the sorting dialogue box as shown.

Sort by color in example 2.4

  • Here select the Sort By option as MRP and Select the Sort On as Font Color.

Sort by color in example 2.5

  • Now select the order by Color, which shows several colors that we have mentioned for the highest MRP.

Automatic example 2.6

  • Click on the font color for MRP, select the color Maroon, and choose the On Top option to get the chosen color so that sorting will be arranged by font color.

On Top option example 2.7

  • Hence the MRP has been sorted by “Font color.”

Sort by color in example 2.8

Example #3

In this example, we will see how to sort font color Year wise where YEAR has been highlighted with several font colors, as shown in the below screenshot.

Example 3.1

  • Select the cell name I, which has the caption name as YEAR.

Sort by color in example 3.2

  • Go to the Data menu and click Sort.

Sort by color in Excel 1

  • Once we click Sort, the sorting feature will either expand the selection or ask the option. Choose expand the selection and click the sort command button.

Sort by color in example 1.3

  • We will get the sorting dialogue box as follows, now choose the Sort by option as Year and choose Sort On with Font Color.

Sort by color in example 3.3

  • We will get the option to choose font color as follows. Now choose the order by Font color, choose the On Top option to get the chosen color on top, and we will get the following result.

Sort by color in example 3.4

  •  The above sales data shows that “year” has been arranged with Font color as specified from Top.

Sort by color in example 3.5

Example #4

In the above examples, we have seen that sorting has been done with cell color and font color by selecting ON TOP.

Let’s consider the same sales data, and now we will see how the sales data appears if we select the order by On Bottom option as follows.

  • Select the Brand column and apply the Sort option; sorting will ask to expand the selection or keep the current selection. So we will select the first option to Expand the selection.

Example 4.1

  • Now we will get the below-sorting dialogue box as follows. As you can see, we have selected the sorting by “Brand” and Sort on “ Cell Color” and select as “Green Color”.

Sort by color in example 4.2

  • Now we will get the results as shown below in the screenshot.

Sort by color in example 4.3

  • We can see the sales data has been arranged Brand wise with the cell color “Green” by default. On Top selection has been chosen.

Sort by color in example 5.1

  • Now select the On Bottom option to see how the sales data can be arranged from the bottom.

Sort by color in example 5.2

  • We have chosen the On Bottom option so that the result will be shown from the bottom.

On Bottom option example 5.3

  • In the below screenshot, we can see the difference that sales data has been arranged Brand wise with the cell color “Green” and the order by one BOTTOM.

Sort by color in example 5.4

Things to Remember

  • While applying Sorting by color, make sure that all colors have been specified with different colors.
  • Make sure that the “My data has the header” option has been check marked.
  • Sort by color can be applied for only one color.
  • We can sort the color with the On TOP or On Bottom option.

Recommended Articles

This has been a guide to Sort by color in Excel. Here we discuss the Sort by color in Excel and how to use the Sort by color in Excel, along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Color in Excel
  2. Alternate Row Color Excel
  3. Sort Column in Excel
  4. Excel Sort by Date
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
2 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Sort by color Excel Template

EDUCBA

Download Sort by color Excel Template

EDUCBA

डाउनलोड Sort by color Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more