Excel Data Validation List And Custom Formula. We can write a custom formula ensure that only specific text is entered into a cell. This formula takes advantage of this behavior to provide a clever way for the user to switch between a short list of cities and a longer list of cities.
Get the free excel workbook with the data validation custom rules examples. 1 choose custom from the allow drop down list. On the settings tab from the allow drop down choose.
On the ribbon s data tab click data validation.
In the ribbon select data data tools data validation. We can write a custom formula ensure that only specific text is entered into a cell. Select custom from the allow list and use the formula below. On the settings tab of the data validation dialog window select custom in the allow box and enter your data validation formula in the formula box.
