C Caroline Keen Mar 3, 2010 #1 Once you have applied conditional formatting, is it possible to count the number of cells that turn the different colours?
Once you have applied conditional formatting, is it possible to count the number of cells that turn the different colours?
F Fred Smith Mar 3, 2010 #2 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
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
