Put on your hardhat and visit Chip Pearson's site:

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


Chris wrote:

I have some code that checks the Interior.ColorIndex of a cell and
acts upon the result. No problem.

I thought that I could alter the Pattern colour (i.e.
Interior.ColorIndex) with a conditional format. I have. No problem.

However the code that acts upon the Interior.ColorIndex does not
detect the changed ColorIndex when it is altered due to the
Conditional Formatting. It reads the value that is set when no
conditional formatting is active (even if it is).

So I need to detect for a conditional format as well. However
.FormatConditions method does not provide any way to read which if any
of the FormatConditions is currently active.

[Aside] Ideally .Interior would return what is currently the case due
to conditional formatting or not. Another method say .InteriorDefault
would yield what we are currently getting. Anyway this is not the case
so I'm fishing for a work around.

Any suggestions

--

Dave Peterson