Excel doesn't provide a built in way to manipulate cells based on their
color. You can, however, create macros that do this. See here for info:
http://www.cpearson.com/excel/SortByColor.htm
Dave
--
Brevity is the soul of wit.
"OKEXCEL" wrote:
Users send me lists that have rows in a colored text, such as red, or they
will high light the rows they want me to see in yellow. I need to be able to
select out only those rows that I need to work with. How can I select rows
base upon the color of the text or if they are high lighted? [EXCEL 2002]