View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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