Finding values based on color
 

Hello,

I have a spreadsheet that has values (entire rows actually) that are colored
in blue and red to signify different circumstances. There are over 100 that
I can see so far. I would like to do a sort that only shows the rows that
are in blue, and then only the ones in red. Is this possible.

BTW, when I say in color, I mean that the font is the object colored, not
the cell.

TIA for your responses.

Phil.

Finding values based on color
 

Hi Phil,

http://www.cpearson.com/excel/colors.htm

--
Kind regards,

Niek Otten

"Phil" wrote in message
...
Hello,

I have a spreadsheet that has values (entire rows actually) that are
colored
in blue and red to signify different circumstances. There are over 100
that
I can see so far. I would like to do a sort that only shows the rows that
are in blue, and then only the ones in red. Is this possible.

BTW, when I say in color, I mean that the font is the object colored, not
the cell.

TIA for your responses.

Phil.

Finding values based on color
 

Niek,

Thanks, I was able to use that technique successfully.

Have a great day.

Phil

"Niek Otten" wrote:

Hi Phil,

http://www.cpearson.com/excel/colors.htm

--
Kind regards,

Niek Otten

"Phil" wrote in message
...
Hello,

I have a spreadsheet that has values (entire rows actually) that are
colored
in blue and red to signify different circumstances. There are over 100
that
I can see so far. I would like to do a sort that only shows the rows that
are in blue, and then only the ones in red. Is this possible.

BTW, when I say in color, I mean that the font is the object colored, not
the cell.

TIA for your responses.

Phil.