I was wondering if this is possible?
I have a bunch of cells (say A1:A10) that each contain a formula suggesting a value, assume A1 has the formula =B1+C1, copied down.
If I then edit A1 manually by typing in a number, I would like the A1 cell to display a different colour (so that I know that I have edited it and there is no longer a formula within it)

Any suggestions as to how I can do this?