Count how many times conditional formatted cells are positive

C

Caroline Keen

Once you have applied conditional formatting, is it possible to count the
number of cells that turn the different colours?
 
F

Fred Smith

Counting by colors requires code (a UDF). However, the simple workaround is
to count by the same condition that triggers the color.

If, for example, your condition is a positive number, then use:
=countif(range,">0")

Regards,
Fred
 
Top