Let’s understand how to sort a column in excel by cell colour and font colour on the data table below.
Sort by Cell colour
I would like to sort the data above by cell colour in City column, all the yellow colour cells should come at top.
Select the data and go to sort under Data ribbon and set the values as shown below by using their drop downs.
Press OK and the data will be sorted on cell colour.
Sort by Font colour
I would like to sort the data above by font colour in City column, all the red colour font should come at top.
Select the data and go to sort under Data ribbon and set the values as shown below by using their drop downs.
Press OK and the data will be sorted on font colour.
Hope this helped.