Color code

[Guest]

I entered rows of data and color coded the text in the rows. How do I sort
the rows by color

 

[Guest]

You need a macro: http://www.cpearson.com/excel/SortByColor.htm

Excel doesn't have a built in sort by color capability.

Dave

 

[Jim Cone]

Excel 2007 claims to be able to do that. Prior versions cannot sort by color.
A macro can do it, see... http://www.xldynamic.com/source/xld.ColourCounter.html
- or -
A commercial alternative (from yours truly)...
http://www.officeletter.com/blink/specialsort.html.
--
Jim Cone
San Francisco, USA


"DHM" <[email protected]>
wrote in message
I entered rows of data and color coded the text in the rows. How do I sort
the rows by color