|
Conditional format to colour cells
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 |
Conditional format to colour cells
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" wrote in message ... 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 |
| All times are GMT +1. The time now is 09:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com