Macros for validating data in excel
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.
Excel date validation provides quite a lot of predefined criteria to restrict users to entering only dates between the two dates you specify, greater than, less than, or equal to a given date.To create the data validation rule, execute the following steps.