Advanced Excel - Sorting Data by Color


If you have formatted a table column, manually or conditionally, with the cell color or font color, you can also sort by these colors.

Step 1 − Click on the DATA tab.

Step 2 − Click on Sort in the Sort & Filter group. The Sort dialog box appears.

Sort Data

Step 3 − Under the Column option, in the Sort by box, select the column that you want to sort. For example, click on Exam 2 as shown in the image given below.

Sort By

Step 4 − Under the topic Sort On, select the type of sort. To sort by cell color, select Cell Color. To sort by font color, select Font Color.

Sort On

Step 5 − Click on the option Cell Color.

Step 6 − Under Order, click the arrow next to the button. The colors in that column are displayed.

Define Order

Step 7 − You must define the order that you want for each sort operation because there is no default sort order. To move the cell color to the top or to the left, select On Top for column sorting and On Left for row sorting. To move the cell color to the bottom or to the right, select On Bottom for column sorting and On Right for row sorting.

Under Order