Use conditional formatting under the Format menu.

make the default color green, and use conditional formatting for the other 3
conditions.

So you don't need to do any programming.


Look at Debra Dalgleish's site under C for additional information
http://www.contextures.com/tiptech.html

--
Regards,
Tom Ogilvy




"glueboy" wrote in
message ...

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