Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...

Hard-coded numbers (also known as constants) being mistaken for formulas is a serious audit risk because they can lead to ...

Make sure you have turned off Dowload Immediately After Validation in the dialog otherwise you won’t be presented with these customization options. You just responded to my que ...