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

--
Regards,
Tom Ogilvy


"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