Macros for validating data in excel options backdating wiki
To pin down existing entries that do not meet your data validation criteria, use the Circle Invalid Data feature as shown in How to find invalid data in Excel.
Surprisingly, none of the inbuilt Excel data validation rules cater for a very typical situation when you need to restrict users to entering only numbers in specific cells.
If users ignore the input message and enter a number that is not valid, you can show them an error alert. Check 'Show error alert after invalid data is entered'.
You can use Excel's Go To Special feature to quickly select all cells with data validation.
In yesterday's tutorial we started to look at Excel Data Validation - what its purpose is, how it works, and how to use built-in rules to validate data in your worksheets.So, for weekdays (Mon to Fri) the result of the formula should be less than 6, and for weekends (Sat and Sun) greater than 5.Allow only workdays: In many situations, you may want to use today's date as the start date of the allowed date range.If you want to validate cells with your own criteria, create a custom validation rule based on a formula.Here's how: Optionally, you can add a custom input message and Error alert that will show up when the user selects the validated cell or enters invalid data, respectively.