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
|