Chris,

See http://www.cpearson.com/excel/SortByColor.htm for example code to sort
by color.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chris Powers" wrote in message
...
Is there a way to do a sort based on the color of the column?

For example, I want red grouped together, then blue, then green. In
theory,
I'd think so as color would be some property of a cell that I'd think I
could access, but I don't know...

thanks,
Chris