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
|