software

I need to compare a scheduled date to today's date and colour/blink a
cell based on results, e.g. steady green would be on time, steady amber
still on time but getting close (2 weeks before due date), flashing red
is past due.
Thanks for your help--
lunar1085
------------------------------------------------------------------------
lunar1085's Profile: www.excelforum.com/member.php...oamp;userid=30639
View this thread: www.excelforum.com/showthread...hreadid=502921Use Format|Conditional Formatting
Formula will be something like =(A1-TODAY())lt;15 then give a colour
Add more conditions; pass due would be =A1lt;TODAY()
Thankfully Microsoft did not provide flashing!

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;lunar1085quot; gt; wrote
in message ...
gt;
gt; I need to compare a scheduled date to today's date and colour/blink a
gt; cell based on results, e.g. steady green would be on time, steady amber
gt; still on time but getting close (2 weeks before due date), flashing red
gt; is past due.
gt; Thanks for your help
gt;
gt;
gt; --
gt; lunar1085
gt; ------------------------------------------------------------------------
gt; lunar1085's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30639
gt; View this thread: www.excelforum.com/showthread...hreadid=502921
gt;