Prev: Index Match with Min
Next: COUNTIFS with a date for criteria...
From: Caroline Keen Caroline on 3 Mar 2010 15:03
Once you have applied conditional formatting, is it possible to count the
number of cells that turn the different colours?
From: Fred Smith on 3 Mar 2010 15:18
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 Keen(a)discussions.microsoft.com> wrote in message
news:735CAC6E-3664-4CAF-A702-F28E165AC7A0(a)microsoft.com...
> Once you have applied conditional formatting, is it possible to count the
> number of cells that turn the different colours?

 | 
Pages: 1
Prev: Index Match with Min
Next: COUNTIFS with a date for criteria...