Jack.
That worked a treat, but how can i expand this so that the cell STAYS coloured for a particular period.
eg. Due date is red. 2-7 days previous turns yellow, 8-14 days previous turns green. I know how to add the colours but adding the additional days is a problem. I should think it is simply adding to the conditional format line but i cannot figure out how to add the additional days.
Sorry to be a pain.
That worked a treat, but how can i expand this so that the cell STAYS coloured for a particular period.
eg. Due date is red. 2-7 days previous turns yellow, 8-14 days previous turns green. I know how to add the colours but adding the additional days is a problem. I should think it is simply adding to the conditional format line but i cannot figure out how to add the additional days.
Sorry to be a pain.