welcome to the forum, Rob. Data validation error would only occur if you key in or do a selection from the cell. for eg. if someone keys in over 300. that is why you get the error only when you double click on the cell and enter. it's akin to keying in.
you might want to consider conditional formatting. say for eg the totals is at M164. go to Home -> Conditional Formatting -> Highlight Cell Rules -> More Rules -> change to Greater or Equals to -> 300
format the color.
alternatively, you might consider VBA. press ALT + F11 to go into the VBE. press CTRL + R to ensure you have the Project Explorer on the left. i would double-click the Sheet1 as that is the worksheet with the totals. you might have to choose your own worksheet the totals are in. once you double-click, the code window appears on the right side. paste this code in:
whenever something changes in this worksheet, it checks if M164 is greater or equals to 300. you have to enable macros after you open my file. and you can add a number in cell B153 for eg to see the prompt appears.
ps: i did this before you attached the file and too lazy to re-do it.
Bookmarks