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
Excel Data Validation custom list
Data validation specific characters only
Excel Data Validation custom list
Data validation no punctuation
Excel Data Validation custom list
Data validation number multiple 100
Excel Data Validation custom list
Data validation whole percentage only
Excel Data Validation custom list
Data validation with conditional list
Excel Data Validation custom list
Data validation unique values only
Excel Data Validation custom list
Data validation must not contain
Excel Data Validation custom list
Data validation must not exist in list
Excel Data Validation custom list
Data validation exists in list
Excel Data Validation custom list
Data validation don't exceed total
Excel Data Validation custom list
Data validation must begin with
Excel Data Validation custom list
Data validation must contain specific text
Excel Data Validation custom list
Data validation allow uppercase only
Excel Data Validation custom list
Data validation allow weekday only
Excel Data Validation custom list
Data validation date in specific year
Excel Data Validation custom list
Data validation date in next 30 days
Excel Data Validation custom list
Data validation require unique number
Excel Data Validation custom list
Data validation only dates between
Excel Data Validation custom list
Data validation allow text only
Excel Data Validation custom list
Data validation allow numbers only