Doh how stupid am I?? What is meant to happen is, if the date in the programmed column is after the date in the due column it should be red, if it is before or equal to it should be green. If blank it should be red. If you could look at that for me please that would be much appreciated. I need to be able to copy it to a worksheet with a number of tabs, and new sheets when they are produced.

Many thanks