how to have a worksheet respond to an anomaly

Hi slipit1,

You should have a look at Data Validation for Q2. You can restrict the values allowed in a range of cells ( a column in your case) to only allow values set by you.