Excel Tip: Sort by Color

In a data area, several cells are selected by highlighting in a different color.  The example show cells that were manually selected, rather than using conditional formatting.  However, if cells are shaded or have a different font color due to conditional formatting, this will work as well.

Excel worksheet with some cells  shaded.

These can easily be sorted to the top of the list.  Place your cursor in one of the cells that has the color to sort to the top.  Right click.

From the pop-up menu, select sort > Selected cell color on top.  This will sort based on the color.

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: