You can help users enter accurate and appropriate information into your spreadsheets with Sheets' data validation feature. Data validation restricts the type of information that can be entered in a cell and can provide the user with instructions for entering information in a cell.
If we enter a value outside of that range, an error marker will appear in that cell. Hovering your mouse cursor over it will display the error message we created.