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.