Detecting Value Changes on a sheet

[soultrain000]

Hi Team,

I have a workbook with Sheet1 carrying the base values which are typed in and another 4 sheets with various formulas feeding from Sheet1.
I want to have a code active all the time which would highlight a cell in yellow if a change has been made to the value either manually or as a result of formula calculation.

Any thought?

Thanks,

 

[Smoakstack]

you should check out conditional formatting. You can highlight cells based on certain values and what not.

Not sure excatly what you are doing, unless you explain in better detail; ie: you want all cells that equal 0 to be yellow.

Hope this helps.

 

[Smoakstack]

I apoligize. I know you were not looking for that. It will need to be done in VBA and I am not sure how to do that.