Hi,

I need to make a cell change colour when anything is written in different
cell.

e.g. when a date is entered into A1:A5, B1:B5 highlight in red. When the
red boxes in B1:B5 are written in to say they have been actioned I need the
cell to return to white. Can anyone help me?

Thanks

Paul