1. Computing
Ted French

Sort Data by Cell Color in Excel

By February 25, 2013

Follow me on:

One of Excel's sort options is to sort data by cell color.

If you have used conditional formatting to change the cell color of data that meets certain criteria then sorting by cell color allows you to group such data together.

Doing so makes it easier to find specific information or to spot trends in a large table of data.

To find out more, read the tutorial on how to Sort Data by Cell Color in Excel.

Related Tutorials

Comments
March 19, 2013 at 8:41 am
(1) Tobi Hossner says:

Great tip, I myself love using conditional formatting to colour and sort after.

What I also found useful is making multiple conditional formatting with 3-4 shades of same colour. Such as darker shade of blue if more relevant data and lighter shade with less relevant. And when sorted, darker shade, higher relevant data will show up first followed by less relevant.

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.