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.