Finding values based on color

[Phil]

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.

[Niek Otten]

Hi Phil,

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

--
Kind regards,

Niek Otten

"Phil" <Phil@discussions.microsoft.com> wrote in message
news:02BBFCD5-9F55-4D89-886D-BA9FBACF8581@microsoft.com...
> 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.

[Phil]

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" <Phil@discussions.microsoft.com> wrote in message
> news:02BBFCD5-9F55-4D89-886D-BA9FBACF8581@microsoft.com...
> > 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.
>
>
>