help with VBA conditional notification emails

that solved the constant emails but the x never leaves A1 unless I delete it myself then it comes back right after sending the email. Sorry if I am bugging you with this it is just the last piece of a month long project and I really want this to work. If it will help here is my worksheet with all the sensitive information hidden, I have been using VBA to put a digital clock in A2 just so cell P28 will update on its own (my work computer just won't let me save it with the macro active).