Question: how to create a data validation rule?
Answer: Select one or more cells to validate., On the Data tab, in the Data Tools group, click Data Validation., On the Settings tab, in the Allow box, select List., In the Source box, type your list values, separated by commas. ... , Make sure that the In-cell dropdown check box is selected.