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

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"DHM" wrote:

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