Colorindex and conditional formatting

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

 

[Gord Dibben]

Quite involved code but see Chip Pearson's site.

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


Gord Dibben MS Excel MVP

 

[Libby]

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