Buzz
In certain cases, when entering data in Excel, you need to validate certain conditions before input. This allows you to have tighter control over your data. In the following article, Mytour will guide you on how to validate data input in an Excel spreadsheet cell.
Validating data input in an Excel spreadsheet cell is not as complicated as you might think, as Excel provides tools to help us validate data input.
Guide on Validating Data Input in Excel
Step 3: A dialog box appears as shown below. Enter the minimum value in cell F10 and the maximum value in cell G10, then click OK to finish.
- Now, when you enter the value 2000 into cell I10, an error will be displayed as shown below.
- Cell I10 only allows you to enter values from 2005 to 2014. For example, if you enter 2006, the data will be entered into cell I10.
Step 4: You can create a message for users to know the conditions you input as follows:
