Data Validation Formula Examples

Data validation can help control what a user can enter into a cell. These formula examples cover commons scenarios you might experience.

Quick Links

Excel formula: Data validation specific characters only

Data validation

Data validation specific characters only

Excel formula: Data validation no punctuation

Data validation

Data validation no punctuation

Excel formula: Data validation number multiple 100

Data validation

Data validation number multiple 100

Excel formula: Data validation whole percentage only

Data validation

Data validation whole percentage only

Excel formula: Data validation with conditional list

Data validation

Data validation with conditional list

Excel formula: Data validation unique values only

Data validation

Data validation unique values only

Excel formula: Data validation must not contain

Data validation

Data validation must not contain

Excel formula: Data validation must not exist in list

Data validation

Data validation must not exist in list

Excel formula: Data validation exists in list

Data validation

Data validation exists in list

Excel formula: Data validation don't exceed total

Data validation

Data validation don't exceed total

Excel formula: Data validation must begin with

Data validation

Data validation must begin with

Excel formula: Data validation must contain specific text

Data validation

Data validation must contain specific text

Excel formula: Data validation allow uppercase only

Data validation

Data validation allow uppercase only

Excel formula: Data validation allow weekday only

Data validation

Data validation allow weekday only

Excel formula: Data validation date in specific year

Data validation

Data validation date in specific year

Excel formula: Data validation date in next 30 days

Data validation

Data validation date in next 30 days

Excel formula: Data validation require unique number

Data validation

Data validation require unique number

Excel formula: Data validation only dates between

Data validation

Data validation only dates between

Excel formula: Data validation allow text only

Data validation

Data validation allow text only

Excel formula: Data validation allow numbers only

Data validation

Data validation allow numbers only

Cover art for 101 Excel Functions You Should Know

Download 100+ Important Excel Functions

I wanted to thank you for your site. I used it heavily when I started working at internships in college and I am now a PhD student who still finds her way back on the site for help. I really appreciate how straightforward and helpful your content is.

Melissa

More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Charts video training course

Video training for Excel Tables

Dynamic Array Formulas