Sorting by Cell Color, Font Color or Cell Icon in Microsoft Excel

Excel sorts data according to specific sort order rules. We can sort the number data as per ascending order and descending order. And sort the text according to alphabets A to Z and Z to A. We can sort by font color and cell color in Microsoft Excel.

This option is available in the Data Tab under the Sort & Filter group.

Let’s take an example to understand how we can sort the data by cell color, font color, etc.

We have data in range A1:B14. In data, some cells and fonts contain color. We want to sort data as per font color and cell color.

To sort as per the cell color, follow below given steps:-

• Select the one cell from data.
• In the Data tab, select Sort, Sort Options dialog box will appear.
• Select Revenue ($) in Sort by Column.
• Select Cell color in Sort on.

• In order column, select cell color on top.

• Data will get sorted as per the cell color.

Sort as per the font color Follow below given steps:-

• Select the one cell from data.
• In the Data tab, select Sort, Sort Options dialog box will appear.
• Select Revenue ($) in Sort by Column.

• Select Font color in Sort on.

• In order column, select font color on bottom.

• Data will get sorted as per the font color.
• Custom List dialog box will appear, click the list of agent’s name, Click on ok.
• Data will get sort as per the custom list.

By following this way, we can sort the data as per fill color and font color.