Excel Data Validation List And Custom Formula. In this example cell a2 is the upper left cell of the selected range of cells. Data validation formula examples examples of formulas you can use to apply data validation in excel.
Custom enter a custom formula. A1 b1 click formatting button change the background or some other colouring so the validation is made obvious click ok. See screenshot for results you still setup your data validation list as per normal for the user to select values from.
Get the free excel workbook with the data validation custom rules examples.
In the data validation dialog box under the settings tab do the following operations. To make data entry easier you can add an excel data validation drop down list to your. On the ribbon s data tab click data validation. We can write a custom formula ensure that only specific text is entered into a cell.
