The Data Validation window that pops up allows you to set your criteria in many ways. For our example, choose Whole Number for Allow:, greater than or equal to for Data:, and -700 for Minimum:.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.

Click the Data tab and select Data Validation in the Data Tools group. A Data Validation dialog box will appear. Under Allow, click the drop-down arrow and select List from the drop-down list.

Discover how a custom data validation tool is transforming education. Learn how we applied statistics to achieve fairness in peer reviews. See how we successfully scaled the "Design Data Products ...

Validation is an automatic computer check to ensure that the data entered is sensible and reasonable. It does not check the accuracy of data. For example, a secondary school student is likely to ...