Conditional format, count cells, formula is , cannot use Cpearson's Active Condition fcn

[seagreen]

Hello,
I've been searching to see if the question I'm about to ask has been solved but so far haven't found an answer. I thought I could use this:
http://www.cpearson.com/excel/colors.aspx

He says:
NOTE: ActiveCondition may result in an inaccurate result if the following are true:

You are calling ActiveCondtion from a worksheet cell, AND
The cell passed to ActiveCondtion uses a "Formula Is" rather than
"Cell Value Is" condition, AND
The formula used in the condition formula contains relative addresses

But, I'm afraid I have a "formula is" type conditional format so the background fill is not "read" by the function. My conditional format rule is like this:
=MATCH(E2,myNamedRange,0) I have a long column with corresponding rules (the E2 become En where n is the row number). I would like to count how many cells are colored. there is only one condition. It's either colored or it's not. I have tried using =COUNTIF with the formula I use in the conditional format rule but haven't any luck.

Can this problem be solved?

Thanks!

 

[Aladin Akyurek]

If

=MATCH(E2,myNamedRange,0)

is the formula in CF, the following would yield a count:

=SUMPRODUCT(ISNUMBER(MATCH(E2,myNamedRange,0))+0)

 

[seagreen]

Aladin @ The Hague: Brilliant! I changed "E2" to E2:E7002 so I could count for the full range and it worked perfectly.
Thanks!!