Sort By Cell Colour And Font Colour In Excel

Let’s understand how to sort a column in excel by cell colour and font colour on the data table below.

Capture

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.

Capture

Press OK and the data will be sorted on cell colour.




Capture

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.

Capture

Press OK and the data will be sorted on font colour.




Capture

Hope this helped.




Share The Knowledge

Random Posts

Leave a Reply