How to Sort by Cell Background Color in Excel

This post will guide you how to sort the selected data by cell background color in Excel. You may add some color to your cells to differentiate it from various other cells so that the data can be easy to read. And you might also need to sort these data based on various colors of cells.

Sort by Cell Color


Assuming that you have a list of data in range A1:B6 with different cell background color and you want to sort those data by their cell color in your worksheet. How to do it. You can do it by the following steps:

#1 select the range of cell that you want to sort the data by cell color.

sort by cell color1

#2 go to DATA tab, click Sort command under Sort & Filter group. And the Sort dialog will open.

sort by cell color2

#3 select one column header from the Sort by list box in the Sort dialog box.

sort by cell color3

#4 select Cell Color option in the Sort On list box. (Note: you can also sort data by Font color or Cell icon)

sort by cell color4

#5 you should see that the order option is visible, and click no cell color drop down list box, and then select the color for the first level.

sort by cell color5

#6 click Add Level button in the Sort dialog box to add the second level and you can select the other colors. Click Ok button to apply these sort settings to your selected range of cells.

sort by cell color6

#7 you should see the following result of sorting the selected range by those cell colors in your worksheet.

sort by cell color7

 

Related Posts

Extract all the matches with helper Column
how to extract all matches with helper column1

With Excel's powerful functions IF, INDEX, and MATCH, we can find exactly what you're looking for with a few clicks of the mouse. This step-by-step tutorial will show how easy it is to extract data using these tools and more! ...

If Cell is This Value or That Value

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of logical test. If you want to see if a cell is A or B, and if one of ...

If Value is Greater Than A Certain Value
If Value is Greater Than A Certain Value 1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the logical test result. If you want to see if a value in one cell is greater than a specific value, ...

If Cell is Not Blank
If Cell is Not Blank 6

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

VBA Macro For VLOOKUP From Another Sheet
vba macro for vlookup from another sheet1

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you how to use VBA code to vlookup data ...

If Cell is Blank
If Cell is Blank_1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if a cell is blank or not, and leave some ...

If Cell Equals Certain Text String
If cell equals certain text_1

IF function is frequently used in Excel worksheet to return you expect “true value” or “false value” based on the result of created logical test. If you want to see if cell equals a certain text string like “Win”, you ...

If Cell Contains Either Text1 or Text2
If cell contains text1 or text2_1

IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to see if cell contains certain substring1 like “abc” or substring2 like “def”, and returns true ...

If Cell Contains Certain Text OR Equals Certain Text

IF cell equals certain text IF function is frequently used in Excel worksheet to return “true value” or “false value” based on the logical test result. If you want to test values to see if they equal certain text like ...

VLOOKUP From Another Sheet Not Working
vlookup from another sheet not working3

In the previous post, you should know that how to fix or remove the #N/A error when using VLOOKUP formula to lookup value from another sheet. And this post will show you reasons why your VLOOKUP formula is not working ...

Sidebar