View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Count how many times conditional formatted cells are positive

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 wrote in message
...
Once you have applied conditional formatting, is it possible to count the
number of cells that turn the different colours?