- Select the cells whose contents you want to validate
- Click the Data tab
- In the Data Tools group, click Data Validation
- On the Settings tab, type the validation criteria
- On the Input Message tab, type the input message
- On the Error Alert tab, type the error message
- Click OK