View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
B. R.Ramachandran
 
Posts: n/a
Default Conditional format

Hi,

Formula Is =AND(TODAY()-$A$114,$J$1="")
and format as you wish.

Regards,
B. R. Ramachandran


"honyacker" wrote:

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