counting

[pierre]

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

 

[Bob Phillips]

=COUNTIF(A1:A10,the _CF_value_tested_for)

 

[Dave]

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.

 

[Dave]

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