Conditional Formatting?

  • Thread starter Thread starter JethroUK
  • Start date Start date
J

JethroUK

I am trying (unsuccessfully) to apply conditional formatting to a column of
dates

It needs to identify dates less than a fortnight old e.g.

Formula is <=TODAY()-14

but i just can't get it to work - any ideas
 
If column A has dates:

3/30/2007
3/31/2007
4/1/2007
4/2/2007
4/3/2007
4/4/2007
4/5/2007
4/6/2007
4/7/2007
4/8/2007
4/9/2007
4/10/2007
4/11/2007
4/12/2007
4/13/2007
4/14/2007
4/15/2007
4/16/2007
and in A1 the Conditional Formatting is
Formula Is:
=A1<=TODAY()-14 and then copied down

This first six cells should be highlighted
 
Assuming TODAY() is the latest date i.e. no future dates:

Date in column A:

Highlight column A

FormulaIs: =A1>=Today()-14

HTH
 
Back
Top