Counting Conditional Formatted Cells

[randysbug]

Is there a way to count cells in a row that are filled red. I don't car
what the value is in the cells I want to count, I only want to know ho
many cells in a range is filled red.

Many thanks!
Juli

 

[Frank Kabel]

Hi
not really possible (Harlan Grove / Bob Phillips posted once a UDF that
checked the conditional format conditions directly). Problem is that
the conditional format does NOT change the colorindex property of the
cell.

So the easiest workaround would be to check for your conditions
manually (e.g. using sUMIF, COUNTIF or SUMPRODUCT)

 

[randysbug]

I was afraid of that.

Thank you, Frank, for your reply

 

[Gord Dibben]

Chip Pearson has some code to deal with CF colors.

http://www.cpearson.com/excel/CFColors.htm

Gord Dibben Excel MVP