Counting conditionally formatted cells
 

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

Counting conditionally formatted cells
 

Hi,

Take a look at Bob's brilliant site :

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

HTH
Carim

Counting conditionally formatted cells
 

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)

"Kebbon" wrote in message
...
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