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
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
Use Format|Conditional Formatting
Formula will be something like =(A1-TODAY())<15 then give a colour
Add more conditions; pass due would be =A1<TODAY()
Thankfully Microsoft did not provide flashing!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"lunar1085" <[email protected]> wrote
in message news:[email protected]...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=30639
> View this thread: http://www.excelforum.com/showthread...hreadid=502921
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks