counting
 

hello
i have a range of : a1:a10
i have made a conditional formatting for cells : a2 , a3 , a5
what formula should be used in order to count the number of cells formatted ??

THANKS

counting
 

=COUNTIF(A1:A10,the _CF_value_tested_for)

--
__________________________________
HTH

Bob

"pierre" wrote in message
...
hello
i have a range of : a1:a10
i have made a conditional formatting for cells : a2 , a3 , a5
what formula should be used in order to count the number of cells
formatted ??

THANKS

counting
 

Hi, Bob,
I couldn't get that to work with =COUNTIF(A1:A16,"TODAY()-15") (for example)
The count returned 0, even with some cells in the range conforming and
firing the CF.
Regards - Dave.

counting
 

Oops, but I have just got it working with:
=COUNTIF(H1:H16,""&TODAY()-15)
Sorry I doubted you!
Dave.