You can also open the Data Validation dialog box by pressing Alt > D > L, with each key pressed separately.
2. Create an Excel validation ruleOn the Settings tab, define the validation criteria according to your needs. In the criteria, you can supply any of the following: