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]

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]

On Xl2002/3 try :

- Edit|Find Options Format Choose Format From Cell,
- Click a cell containing the color you want to find, then Find All.
- Press Ctrl+A to select all items containing that formatting.

If cells are in a column you could then copy this selection to another
sheet.

On Jan 24, 5:01 pm, 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]