Conditional Format based on if a cell has been altered

[Guest]

I would like to use the Conditional Formating tool to highlight a cell if the formula in a cell has been manually overwritten or changed. Any way to do that? Your help greatly appreciated.

- David

 

[Debra Dalgleish]

Conditional formatting can highlight a cell based on its value, or the
value of other cells, but wouldn't detect if a value has been manually
entered, or if a formula has been changed.

You could use the Worksheet_Change event to colour a cell if its value
is manually changed. Chip Pearson has information on event procedures:

http://www.cpearson.com/excel/events.htm