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