Hi all
I have an job that requires the contents of a cell to change color depending
on how many weeks there are yet to run before the job is due. ie a visual
'heads up' of what is coming up.
Contents or text would follow like this - If due this week, RED, if due next
week, orange, if due in two weeks, yellow, if due in 3 weeks, green.
As the project is based on week numbers, it would be best for the formula to
based on that.
Regards
Roger