how 2 Count number of cells that have specific condition format?
 

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.

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.

You need to replicate the conditional form at test. So, say the CF test
colours it red if cell value 10. Then you need to count the number of cells
10.

--
HTH

Bob Phillips

"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.