Evaluate conditional formatting in code
 

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

--
Message posted from http://www.ExcelForum.com

Evaluate conditional formatting in code
 

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



"Marq <" wrote:

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

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

Any ideas without having to evaluate the condition text itself?

Thanks
Marq

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

Evaluate conditional formatting in code
 

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

--
Message posted from http://www.ExcelForum.com