Can macro test fill color in cell with conditional format?

[John Keith]

Is it possible for a macro to test the fill color that is generated by
a conditional format? If so, how?

TIA


John Keith
(e-mail address removed)

 

[Gary''s Student]

This topic is very well covered in:

http://www.xldynamic.com/source/xld.CFConditions.html

 

[John]

This topic is very well covered in:

http://www.xldynamic.com/source/xld.CFConditions.html

Thank you! That is an excellent reference. (Why didn't that show up on
my google search???)

JK

 

[Gary''s Student]

xldynamic does not cover a vast number of topics, but what it does cover, it
covers very thoroughly.

There are a number of other websites that give excellent Excel hints and
tutorials.