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