Mark cell when changed

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

Hello,

I have an Excel sheet which is filled with formulas linked to a data
warehouse. To be able to easily detect changes in the the past I was
wondering if you can format a cell so that it (for example) turns red
as soon as the value in it changes due to an update of the sheet.

Hope that someone can advice me.

Thanx very much in advance.

Regards,
Robert
 
Robert,

A worksheet_change event macro could mark the cells with red, but since
you're sheet is links to the original data, that won't fire the macro.

You need to think about when you'll reset the colors. Perhaps a better
approach would be to save all the data (as hard values, perhaps with paste
special - values) at that time, then at the next inventory, compare the
saved with the current.
 
Back
Top