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

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

It was clear, but thanks for the clarification. I looked for the condition and was able to move on. Thanks for the feedback (both of you)

Lance

"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

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

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