Conditional Formatting?
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
--
Gary''s Student - gsnu200716
"JethroUK" wrote:
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
|