Counting conditionally formatted cells

[Kebbon]

Hi,
I am looking for a formula that allows me to count the cells in a range that
have been conditionally formatted. By this I mean only those cells that
have satisfied their respective conditions and therefore have had the
special formatting applied.
Thanks

 

[Carim]

Hi,

Take a look at Bob's brilliant site :

http://www.xldynamic.com/source/xld.CFConditions.html

HTH
Carim

 

[Bob Phillips]

The simplest way is to sum using the same tests as the CF.

If you want another solution, look at
http://www.xldynamic.com/source/xld.CFConditions.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)