View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

The easiest way is to use a countif or sumproduct for the same condition as
the cf.

--
Don Guillett
SalesAid Software

"daveydavey" wrote in message
...
Some time I need to count number of cells that have a cpecific conditional
format. Say how many cells have shade of certain color?

The cell might have some information or just balnk with the desiganted

color
only.