Conditional formatting of dates

[EJ]

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

 

[Mike H]

I've never used 2007 but this works for 2003.

Select column F then
Format|Conditional format
Formula is
enter the formula
=AND($F1<>"",$F1<TODAY()+365)
Pick a colour
Click OK

Mike

 

[EJ]

That worked a treat!

Thank you very much for your time

EJ