Conditional Formatting

N

Nikki

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
 
G

Gary''s Student

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.
 
N

Nikki

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
 
M

Michael

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
 
N

Nikki

Michael:

Thanks for your help.

Michael said:
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
Click to expand...
 
Top