How to use Custom Data Validation in Excel

How to use Custom Data Validation in Excel and set up validations like restricting entry to text, specific dates, numerical entries and more.
In this Excel tutorial you will find how to:
==============
1.Prevent the entry of future dates
2. Allow entries dependant on another cell
3. Allow only Text Entries
4. Only text entries with a specified length
5. Allow only upper case letters
6. Allow entry of weekdays only
#ramgopalexcel
**Link to get Microsoft Office 365:**

Disclosure: The above link is an affiliate link, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase.

[pradyumnasatapathy]

This is so wonderful, and your explanation is great. Thank you

[jacinthandrew]

This is very useful, thank you, pls advise if there is a way to replace a one with a word ?

[mohamadraffi]

Very helpful content. Thank you Mr.Ram Gopal Ji

[SRT]

Appreciate your simplified explanation. Could you also please make simplified videos on pivot tables and power querry in excel. Thank you.

[georgeregoo]

Excellent. But what about entry of a mix of character and Numeric (example a part No)

[rcnethreshgowda]

Sir if there are any criteria's means we can use some if or sumifs function right then why we are nor using sumif or sum ifs for custom data validation ?

[maheshmurugan]

Can you make a video, which is based on OFFSET .

[archanaaa]

Sir. How to use data validation for duplicate list?

[sudhan]

Great ! but this validation is not in special paste scenario.

[ashvinkalleejaisriram]

I want to validate each cell that none can be blank. How to do same

[Pakidesivlog]

Today()
2*b2
Istext()
Isnumber()
AND(istext(), (len()<6))
exact(b3, upper())
weekdays(b2, 2)<6