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

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.
--
Gary''s Student


"Nikki" wrote:

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

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

"Gary''s Student" wrote:

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.
--
Gary''s Student


"Nikki" wrote:

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

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
--
Sincerely, Michael Colvin


"Nikki" wrote:

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

"Gary''s Student" wrote:

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.
--
Gary''s Student


"Nikki" wrote:

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

Michael:

Thanks for your help.

"Michael" wrote:

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
--
Sincerely, Michael Colvin


"Nikki" wrote:

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

"Gary''s Student" wrote:

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.
--
Gary''s Student


"Nikki" wrote:

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