Create a Pop Up Message

Hi
I am trying to create a pop up message that gets users to double check their figures. It is based on a figure that is calculated from other cells using a formula.

EG. In CELL J5 the entry figure is $470.00. the user has to enter a figure into cell J6. In cell J7 there is a formula to calculate the difference between J6 and J5

now if J6-J5 is within a range of Negative $10 to $10 then everything is ok.

If the difference is outside this range then I need a message to alert the user to double check their counts.

Can someone please help??

Thanks

Hi. I get how to do this, however I cant make it work while still having the formula in J7.

The pop up message is to be activated because of the figure in J7 which is calculated from the difference between J5 and J6.

Not how I need it to work.

see my attached

sorry wont let me attach

but basically where you have 450 in j5, there is another cell that using a formula calculates J6-J5 so if the difference is -10 or lower or 10 or higher then it displays the pop up message

thanks

that looks like it... thank you very much

The only issue now that I see is that I need the J7 to reflect the difference as a negative (if it is) (eg 450-470 = -20). it is showing a positive number as the difference no matter which way. can that be done

SORRY, another thing I found with that, is if the figure is inside the range, the different figure doesn't show in the cell.

I need the DIFFERENCE column to show either the positive or negative figure whether within the range or not. Also I need the error message to appear if the figure is outside the range


thank you for all your assistance

thank you very much for your persistence., looks like I have what I need. very much appreciated

it looks as though it has... I have more of the spreadsheet to create but it all should be good now...