Colorindex and conditional formatting

L

Libby

Hey Guys,

I'm looping through some cells which have conditional formatting applied to
make then green, red or grey. The colours all represent the same thing (i.e.
green = yes), but the criteria that applies the format is not constant
throughout.

To avoid this I attempted to use the interior colorindex to return the
status of the cell, but the colorindex property seems to ignore the colours
resulting from the conditional formattng.

Does anyone know how to return the interior colour of a cell that results
from conditional formatting without using the value of the cell?

Many thanks in advance.
 
L

Libby

Thanks Gord - I have looked at Chip's code. I was kinda hoping there would
be a simpler solution...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top