Highlight cell when overriding formula???

Hi
I have a cell with a formula that returns a value, when the user decides this value is no good then he/she will override the formula and input another value.
I need to highlight the cell when the user decides to override the formula with a value. (possibly using conditional formatting)

e.g.
A1 includes a formula that returns 500. (with white background)
User decides to input 400 into A1.
Cell A1 should highlight background as blue to indicate that the formula no longer exists.

thanks for any help
Arfan

Hi,

There is a Change Tracking tool that you could use to achieve this. Googling or using Help will show you how to do this.

HTH,

SamuelT

Using the 'change tracking' method does not give want i really need.

If a cell has a formula (if statement) that outputs a numeric result (e.g. 500), the cell stays white. If the cell is overriden by inputting any number or text then the cell will turn blue. However if a number of the same expected result (500) is inserted into the cell (not the formula) then the cell will stay blue as the formula does not exist. And finally if the formula is re-inserted into the cell the cell will return to white.

Any takers.

thanks.

OldChippy's link is what you want. The only difference is that in the conditional formatting you will want to put =NOT(CELLHASFORMULA)

ChemistB