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
donaldb@281.com
"daveydavey" <daveydavey@discussions.microsoft.com> wrote in message
news:059D38EF-4970-4E9B-9F1C-008FEB6A4B13@microsoft.com...
> 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" <daveydavey@discussions.microsoft.com> wrote in message
news:059D38EF-4970-4E9B-9F1C-008FEB6A4B13@microsoft.com...
> 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.