Can I sort Excel by color? Absolute. Excel can not only sort by values, but also by cell color, font color, and cell icon.
First, you must define the colors for your sort columns / fields. In this example, we select colors based on the column SALES.
. 1 Mark all lines with a turnover of 100 to 500 million. To select a background color, click Home in the main menu bar and go to the Font group. Find the paint bucket icon that represents Fill Color and click the down arrow next to it. A color palette is displayed from which you can select a color by clicking on the thumbnail. For our example, we have selected yellow from the group Standard Colors.
. 2 Highlight the next group with sales of 77-85 million, then select Blue.
. 3 Choose between 60 and 65 million green. for 50 million choose Orange; Choose lavender for 40 to 45 million and cyan (turquoise) from 30 to 39 million.
Now The colors are defined by SALE, you can use them to post to BOOK , AUTHOR, LANGUAGE or PUB DATE and, for example, to display authors with a turnover of cyan, which denotes the group with a conversion between 30 and 39 million.  1. Move the cursor anywhere within the data range and press Ctrl + A to highlight everything.
. 2 On the Home tab, in the main menu, select the group Edit . Click Sorting and Filtering> Custom Sorting . The Sort dialog box opens.
. 3 If you have headers, check the box . My data has headers .
. 4 Select a sort key from the Sort By field under Column such as Author .
. 5 Under Sort On select Cell Color from the drop-down list.
. 6 Under Order select the thumbnail for the color you want to sort by – in our example, it's cyan.
. 7 And in the last box, select On Top which places the selected rows at the top of the spreadsheet (select On Bottom sorts the selected rows down).  8. Then click the Add Level button to add a second sort key to the query.
. 9 Select from left to right AUTHOR Cell Values A to Z and click OK first by color, then by author "width =" 700 " height = "296" data-imageid = "100783040" data-license = "IDG" /> JD Sartain / IDG Worldwide Sort spreadsheet by color first, then after AUTHOR
Sort spreadsheet by color first, then after AUTHOR
Note that all cyan Cells (30 to 39 million in SALES) are sorted upwards and then sorted alphabetically by AUTHOR within the cyan cells, the rest of the worksheet being sorted according to AUTHOR only with all remaining SALES sums (except 30 to 39 million).
Other examples and detailed instructions for sorting by F You can find the values, symbols, and the use of conditional formatting in the following two articles: How to Use Conditional Formatting in Microsoft Excel and How to Customize the Conditional Formatting of Excel.