Count how many times conditional formatted cells are positive
 

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

Count how many times conditional formatted cells are positive
 

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

"Caroline Keen" <Caroline wrote in message
...
Once you have applied conditional formatting, is it possible to count the
number of cells that turn the different colours?