Use a counting formula that makes the same tests as the CF, such as

=SUMPRODUCT(--(A2:A20=TODAY()-7),--(A2:A20<TODAY())



--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Chad" wrote in message
...
I have a column of cells that have conditional formatting to change the
cell
color & text style if the condition is true.

Is there a way to count the total number of cells in which the conditional
formatting is true?

Thanks in advance.