Count how many times conditional formatted cells are positive

[Caroline Keen]

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

 

[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