Check value difference between old and new input for cell formula

[Gonio]

Hey there,

Sorry for my poor English in advance, am no native speaking and writing person. This question has to work in Excel 2007.

For an sheet what we use to store the hours as an indication for what we need, I need a formula. But no idea how to get it done since my knowledge of Excel is basic.
Multiple people fill in their hours and sometimes adjust them. So if it is previously 6 and they need more (9 for example), they just type in that specific cell 9 and thereby overwriting the 6.
Problem is that we want to track the changes with a formula and if needed add a cell color, but I am uncertain on what function accomplish this. I know how to format it, so I can add a cell color. It is the part from the change between old and new value where I am not certain on what to do.

So as example of what we want: If in cell C6 is a value of 6 and someone adjusts it to 14, the difference is 8. So the formula must detect that the change is equal or more then 8. With formatting it we make the rule that the cell is shown in orange. If the change between the old and new value is 7 or less, nothing happpens besides the value change.

Thx for the help in advance

Gonio

 

[FDibbins]

Problem is that we want to track the changes with a formula and if needed add a cell color,

There is no formula that will do this for you, you will need VBA. A formula works on what is currently in a cell, and has no way of knowing what used to be there

 

[Gonio]

There is no formula that will do this for you, you will need VBA. A formula works on what is currently in a cell, and has no way of knowing what used to be there

Ok, well that explains why I couldn't find it. Seems I have to start my future VBA plans for the sheet sooner then. Planning to make a form they need to fill out so we can protect our data being changed accidently. Already got somethings of the code functioning with buttons etc, but my experience with VBA is almost only Google Got a idea for the code needed to make this work? Thx in advance.