Conditional formatting of dates

  • Thread starter Thread starter EJ
  • Start date Start date
E

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
 
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
 
Back
Top