Evaluate conditional formatting in code

[Marq]

I have conditional formatting on a bunch of cells which works fine.

In code I want to evaluate if that conditional formatting has bee
triggered ie have the conditions been satisfied.

Any ideas without having to evaluate the condition text itself?

Thanks
Mar

 

[Dave Peterson]

Take a look at Chip Pearson's site:
http://www.cpearson.com/excel/CFColors.htm

 

[Marq]

Thanks for the reference. I was hoping not to have to evaluate the C
for each cell but it looks like I will.

Regards
Mar