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?