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

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

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

=(A1TODAY()+14)*(ISBLANK(J1))

"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

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

=and(today()-a114,j1="")


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=506359

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