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.