Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a logical test for a cell's format instead of contents | Excel Worksheet Functions | |||
Create conditional IF to format cells using 6 different colours | Excel Worksheet Functions | |||
Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) | |||
conditional format of data tables in charts | Charts and Charting in Excel | |||
conditional format | Excel Worksheet Functions |