Counting of specific Conditional Formats

  • Thread starter Thread starter Ruan
  • Start date Start date
R

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
 
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
 
This might seem too simplistic, but why not just use the conditiona
formula itself, together with COUNT. or similar function.

TGHCOG
 
Back
Top