Excel Data Validation custom list

Data Validation Formula Examples

Examples of formulas you can use to apply data validation in Excel.

See also: Data Validation Guide | Dependent Dropdown Lists
Data validation specific characters only
Data validation no punctuation
Data validation number multiple 100
Data validation whole percentage only
Data validation with conditional list
Data validation unique values only
Data validation must not contain
Data validation must not exist in list
Data validation exists in list
Data validation don't exceed total
Data validation must begin with
Data validation must contain specific text
Data validation allow uppercase only
Data validation allow weekday only
Data validation date in specific year
Data validation date in next 30 days
Data validation require unique number
Data validation only dates between
Data validation allow text only
Data validation allow numbers only