View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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