Hi

I have a series of cells which calculate the date various information is required by, which get overtyped when information is received.

Is it possible to have the cell automatically highlighted when the formula is present, but clear when it has been overtyped?

Thanks for your help

Jon