Hi all,

Am using Excel 2007, and trying to highlight dates in a column (F) that are
within one year of today.

If I run the following function on each date in the column, it behaves as
expected:
=IF(F3<(TODAY()+365),"RENEW NOW","OK")

Now, if I try to now do a conditional format on the column, highlighting all
values that are TRUE (ie: need renewing) using the following, it just
highlights every value (there are definite dates which are "OK":

=F:F<(TODAY()+365)

Have not really played with conditional formatting before, so I am probably
doing something embarrassingly wrong.

Could anyone lend a hand please?

Thanks in advance

EJ