View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ian
 
Posts: n/a
Default Conditional format

Formula is
=AND(DAY(TODAY()-A1)14,J1="")
should do it.
--
Ian
--
"honyacker" wrote in message
...
I want to highlight a cell based on two conditions:
I want to highlight cell A1 if the date in cell A1 is over 14 days older
than TODAY() and cell J1 is blank.

Joe