Can you sort based on conditional formatting in Excel?
You cannot currently sort a cell range based on the conditional formatting, however an alternative is to insert the same condition in the corresponding row or column, so it returns True or False. You can then sort by this row or column.
Why can't I sort by color in Excel?
Click the Sort By drop down and select 'Marks'. This is the column based on which we want the data to be sorted. In the 'Sort On' drop down, click on Font Color. In the 'Order' drop-down, select the color based on which you want to sort the data.