Conditional format
 

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

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

Conditional format
 

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

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

Conditional format
 

=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

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