msgbox popup when a formula result changes...

Been reading for days here to find the answer to this...

Have learned a TON of stuff on the way.

I am looking to have a message box fire when certain cells or "records" change. Problem is, the cells have MIN/MAX formulas that reference cells that have other formulas that reference other cells that have SUM formulas in them... (did that make sense?).

I would like the box to popup with something along the lines of 'You broke a record!'... etc. Down the road I'll try and have it tell me which record.

Can anyone share some input? I've attached the spreadsheet and highlighted the cells I'd like to be notified about when they change.

Thanks in advance!

Not sure I have an answer for that... just used the same formulas in all 3 boxes... will definitely change that though.

Yup... nothing in those columns is entered on that worksheet. At the end of each of my managers' shifts, they use that button to go to the daily sheet and enter their results. I would like for that to fire after they enter their numbers and go back to the overall tracking form.