Excel doesn't remember previous values, and if it did it would create a
circular reference. You need a macro to savve the old value into another
cell.


"DD" wrote:

Is there a function that I can use to calculate the amount a single cell has
changed without using VBA?

So if Cell A1 had a 5 in it and someone changed it to 7 I want to show it
changed 3.