Conditional format

honyacker · Jan 30, 2006

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

Ian · Jan 30, 2006

Formula is
=AND(DAY(TODAY()-A1)>14,J1="")
should do it.

Sloth · Jan 30, 2006

select "formula is" and input this formula
select the appropriate format

=(A1>TODAY()+14)*(ISBLANK(J1))

B. R.Ramachandran · Jan 30, 2006

Hi,

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

Regards,
B. R. Ramachandran

Cutter · Jan 30, 2006

=and(today()-a1>14,j1=""

honyacker · Jan 30, 2006

Thank you all very much.
Works great.
Joe

Conditional format

honyacker

Ian

Sloth

B. R.Ramachandran

Cutter

honyacker