Conditional Formatting

[Guest]

Hi,

I was wondering if I had conditional formatting set up in a column which
resulted in some cells to be in Pink, is there any formula that I can use to
find only pink cells. I want to extract only pink cells in a separate
worksheet, but I can not think of any formula that will find specific format.

Thanks in advance.

Nikki

 

[Guest]

You are most of the way there.

You already have criteria that makes the cell pink. Use the same criteria
in Filter > Advanced Filter to select only these cells and make them
available for copying.

 

[Guest]

I would not work because there are breaks in the data and I have to filter
many times to get all the information. I ended up using if statments to find
the critaria.
thanks for your help.

Nikki

 

[Guest]

Nikki, check out Chip Pearson's site about functions with colors. Scroll
down and there is a link working with colors implemented by conditional
formatting. HTH

 

[Guest]

Michael:

Thanks for your help.

Nikki, check out Chip Pearson's site about functions with colors. Scroll
down and there is a link working with colors implemented by conditional
formatting. HTH