Hi, I'm using a spreadsheet at work which other people complete but one of the cells I have put in data validation that highlights any values below 150,000 so if you enter 49,000 you get an error message saying its too low.
However, one of my colleagues changed the data validation parameters to allow the sheet to accept the lower value. Is it possible to lock the data validation so people can't fiddle with it?
Bookmarks