Counting of specific Conditional Formats

[Ruan]

Hello,

Is it possible to count a specific Conditional Format? For example: Any
missing data in a column range due to certain criteria I highlight the cell
in Red. What I would like to do is count those red cells and have a
"Missing" total at the bottom of the range.

Is this possible?

Thanks
Ruan

 

[Gord Dibben]

Ruan

Not too easily.

You can't return the colorindex of CF colored cells.

Could you count using the original condition that turned the cells red?

e.g. =COUNTIF(cellrange,">10")....or whatever the criterion is

For more of CF colors and code see Chip Pearson's site.

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

Gord Dibben Excel MVP

 

[pikapika13]

I think I can help...can you send a specific example

 

[tghcogo]

This might seem too simplistic, but why not just use the conditiona
formula itself, together with COUNT. or similar function.

TGHCOG