Forum Discussion
how to use the change of a cell value as a condition
Hello,
I am trying to create a conditional function based on the change of a cell value. ie:
I have 2 cells, B3 (that contains a date) and C3(that is empty).
I would like to write in C3: IF B3 changes THEN C3="changed" ELSE C3="unchanged".
The table is connected to a data base and I want to see if new dates are updated in the column B.
Does anyone know a function that confirms if a cell has changed or not? I am hoping I won't need to use VBA.
Thank you kindly
Bo_Songa changed from what? when? I know what you want but what I see is you look at the sheet today and the date in b3 is Jan 1,2020 and you create the magic formula in c3. Now the next time you look at the sheet it is Feb 1, 2020 and the formula say "changed" yay. But now what? Do you expect this magic formula to reset? if so when? if it resets too soon maybe you won't notice it said changed before it resets to unchanged.
I think the easiest you could do is make d3 =if(b3=c3,"unchanged","changed")
and then each time to visit the sheet you copy b3 (or col b) and paste values into c3 (or col c)
*edit* actually 1 more thought. what about making formula in c3 =b3 and turn calculation to manual only. If the database causes the sheet to update and save you might have to disable the default 'calculate before saving' and then you have to click 'calculate now' before you exit and save.
7 Replies
- Hello, I didnt catch what you mean by IF B3 Changes to what?
Bo_Songa changed from what? when? I know what you want but what I see is you look at the sheet today and the date in b3 is Jan 1,2020 and you create the magic formula in c3. Now the next time you look at the sheet it is Feb 1, 2020 and the formula say "changed" yay. But now what? Do you expect this magic formula to reset? if so when? if it resets too soon maybe you won't notice it said changed before it resets to unchanged.
I think the easiest you could do is make d3 =if(b3=c3,"unchanged","changed")
and then each time to visit the sheet you copy b3 (or col b) and paste values into c3 (or col c)
*edit* actually 1 more thought. what about making formula in c3 =b3 and turn calculation to manual only. If the database causes the sheet to update and save you might have to disable the default 'calculate before saving' and then you have to click 'calculate now' before you exit and save.
