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!
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!