Considering cells colored via conditional formatting
 

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

Considering cells colored via conditional formatting
 

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)


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=174510

Microsoft Office Help

Considering cells colored via conditional formatting
 

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