Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date warning
hi all... as part of my job, i have to manage an enormous number of deadlines etc, and was wondering if there's a way of having the deadline column change the colour of the text within date cells that are imminent? for example, if a date is over a week away, it could remain green, if it's within a week, then it could be amber, within three days = orange, and on the deadline (or overdue) = red. sadly, i have next to no programming knowledge, but would really appreciate it if anybody could offer suggestions? thanks, glueboy. -- glueboy ------------------------------------------------------------------------ glueboy's Profile: http://www.excelforum.com/member.php...o&userid=28784 View this thread: http://www.excelforum.com/showthread...hreadid=484727 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Warning with near date | Excel Discussion (Misc queries) | |||
Date Warning | Excel Discussion (Misc queries) | |||
warning with concatenated date | Excel Discussion (Misc queries) | |||
Date of expiry - warning? | Excel Worksheet Functions | |||
Warning message base on date | Excel Worksheet Functions |