Thanks bigbas that's kind of exactly what I wanted. Do I put that code on every worksheet? When I put it on worksheet10 and change values in worksheet1 making values in worksheet10 go negative, it throws me some kind of method intersect of global failed. It does work if I'm actually on worksheet10 though. Also it's giving me a msgbox everytime an yvalue changes whether is negative or positive, but I think I can probably figure how to fix the code so it only does it for negative values only.