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

Mike F
"Faraz A. Qureshi" wrote in
message ...
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.
--
Thanx in advance,
Best Regards,

Faraz