Link to home
Start Free TrialLog in
Avatar of Line One
Line One

asked on

Excel - sort by colour?

I have a spreadsheet that has rows of different colors that are not contiguous. Is there a way to sort by color so that all the red rows appear together for example?
Avatar of Flyster
Flyster
Flag of United States of America image

Select a column that has the colors you want to sort. On the Home tab under Editing select Sort & Filter, Custom Sort. In the Sort dialog box uner Sort On, select Cell Color.

Flyster
Whether you can sort by color depends on the version of Excel. Excel 2007 and 2010 permit it. Excel 2003 and earlier do not.
Avatar of Line One
Line One

ASKER

Flyster:
Thanks for the tip. I'm not clear however on what you are suggesting.  You write:
"Select a column that has the colors you want to sort."
No column has all the same colour. As I said the colored rows at not contiguous - so there may be 3 red rows, 4 green rows, a red row, etc.

Did you mean row not column?
ASKER CERTIFIED SOLUTION
Avatar of Flyster
Flyster
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Got it. Thanks.