software

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.

JoeFormula is
=AND(DAY(TODAY()-A1)gt;14,J1=quot;quot;)
should do it.
--
Ian
--
quot;honyackerquot; gt; wrote in message
...
gt;I want to highlight a cell based on two conditions:
gt; I want to highlight cell A1 if the date in cell A1 is over 14 days older
gt; than TODAY() and cell J1 is blank.
gt;
gt; Joe
gt;
gt;
gt;
gt;
select quot;formula isquot; and input this formula
select the appropriate format

=(A1gt;TODAY() 14)*(ISBLANK(J1))

quot;honyackerquot; wrote:

gt; I want to highlight a cell based on two conditions:
gt; I want to highlight cell A1 if the date in cell A1 is over 14 days older
gt; than TODAY() and cell J1 is blank.
gt;
gt; Joe
gt;
gt;
gt;
gt;
gt;

Hi,

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

Regards,
B. R. Ramachandranquot;honyackerquot; wrote:

gt; I want to highlight a cell based on two conditions:
gt; I want to highlight cell A1 if the date in cell A1 is over 14 days older
gt; than TODAY() and cell J1 is blank.
gt;
gt; Joe
gt;
gt;
gt;
gt;
gt;


=and(today()-a1gt;14,j1=quot;quot;)--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=506359Thank you all very much.
Works great.
Joe

quot;honyackerquot; gt; wrote in message
...
gt;I want to highlight a cell based on two conditions:
gt; I want to highlight cell A1 if the date in cell A1 is over 14 days older
gt; than TODAY() and cell J1 is blank.
gt;
gt; Joe
gt;
gt;
gt;
gt;