I have a range of cells that contain formulas, but I also need to give the
user the option to manually overwrite the result of any of these formulas.

Where the formula is overwritten I want the cell shading to turn yellow. I
can't see a way of doing using the Conditional Formatting tool.

Is there something else I could try ??