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

D

daveydavey

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

Don Guillett

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

Bob Phillips

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
 
Top