Considering cells colored via conditional formatting

[Faraz A. Qureshi]

EXCEL 2007

Any piece of code which, for example, select or count the cells which are
colored yellow, amongst the currently selected range, because of meeting ANY
criteria of CONDITIONAL FORMATTING.

In other words, considering cells which are not actually possessing yellow
as an interior color but being displayed so because of CONDITIONAL FORMATTING.

 

[joel]

There are two pages at Chip Pearson's wepage that you need to look at.
the 2nd gives a detailed example of how to do what you want.


'Conditional Formatting
(http://www.cpearson.com/Excel/cformatting.htm)
'Conditional Formatting Colors
(http://www.cpearson.com/Excel/CFColors.htm

 

[Mike Fogleman]

Consider Chip Pearson's offering on this subject:
http://www.cpearson.com/excel/colors.aspx

Mike F