Hi Tom
after re-reading my post I just could say: thanks for the clarification
<vbg
Definetely needed even if the OP was able to decipher it :-)

--
Regards
Frank Kabel
Frankfurt, Germany


Tom Ogilvy wrote:
I understand what Frank is saying, but it may not be clear to you.
Frank is saying there is no direct way to check the color in the cell
which is produced through conditional formatting. A more direct
approach is to check the same condition the conditional formatting is
checking.

An generalized approach is to do that dynamically as Chip Pearson
demonstrates -

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


"Frank Kabel" wrote in message
...
Hi
the conditional format does NOT change the colorindex property. So
though it is possible to check for the condtions you may better
check
the conditions manually in your code

--
Regards
Frank Kabel
Frankfurt, Germany


lance wrote:
If a cells interior is set to red through conditional formatting,
where do you programatically check for red

.cells(1,1).interior.colorindex

does not seem to change when set by conditional format.

Lance