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

Thank you all very much.
Works great.
Joe

"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