Sorting by color can be useful if you are using conditional formatting, which allows you to change the background color or font color of data that meets certain conditions.
Sorting by color can then be used to group this data together for easy comparison and analysis.
Sort by Font Color in Excel ExampleFor help with this example, see the image above.
- Enter the following data into cells D1 to D6: 40, 20, 30, 60, 5, 25.
- Use the mouse and CTRL key on the keyboard to select cells D1, D3, D5.
- Click on the Home tab of the ribbon.
- Click on the down arrow next to the Font Color icon on the ribbon to open the Font Color drop down list.
- Choose red from the samples of colors available in the list to change the font color of the data in cells D1, D3, D5 to red.
- Drag select cells D1 to D6 to highlight them.
- Click on the Sort & Filter icon on the ribbon to open the drop down list.
- Click on Custom Sort in the drop down list to bring up the Sort dialog box.
- Since our data does not have a heading, if necessary, click on My data has headers at the top right of the dialog box to remove the check mark.
- Under the Sort On heading in the dialog box, choose Font Color from the drop down list.
- When Excel finds different font colors in the selected data it adds those colors to the options listed under the Order heading in the dialog box.
- Under the Order heading, select the color red from the drop down list.
- If necessary, chose On Top under the sort order so that the red-colored data will be at the top of the list.
- Click OK.
- The data in cells A1 to A6 should now be in this order:
40, 30, 5, 20, 60, 25.