counting

P

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
 
D

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

Dave

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