Hi,

I need to be able to manually input the dates in column D, therefore I am unable to use a formula in this column...hence why it might be better to conditionally format?

Thanks