Question: how to create a data validation rule in excel?
Answer: Select the cell or cells that need a rule. On the Data tab, click the Data Validation button. ...  On the Allow drop-down list, choose the category of rule you want. Enter the criteria for the rule. ...  On the Input Message tab, enter a title and input message.