If you've used data validation in Excel before, you probably selected the relevant cells, clicked "Data Validation" in the Data tab on the ribbon, and created the rule in the Data Validation dialog ...

Microsoft Excel allows the entry, storage and organization of a large amount of data to be user-friendly. However, when entering data, you may not have explicit values available for all columns in ...