Can you sort excel data by color coded cells?

[lbs]

I have a report that has a column coded by color. Is it possible to sort by
color to get each color lumped together?

 

[Bob Phillips]

If it is not conditionally formatted colour, see
http://www.xldynamic.com/source/xld.ColourCounter.html#sorting

 

[Chip Pearson]

Only with VBA. See http://www.cpearson.com/excel/sortbycolor.htm
for details and examples.


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