Data validation is a feature in Excel which are used to impose the restriction on a cell that which type of data you can enter and which type of data you cant enter. One of the most power full option of Validation is Custom Validation means with the help of user define formula. Data validation formulas must be logical formulas that return TRUE when input is valid and FALSE when input is invalid.
If you have any problum with this video then clickbelow to direct download this file
Cell Address or Cell Reference In MS Excel
Formula In MS Excel
Function In MS Excel
Absolute and Relative Reference in MS Excel
Formatting In MS Excel
What Is Conditional Formatting in MS Excel
IF Function in MS Excel
Nested IF Function in Excel
Filter In Excel
Sorting in Excel
Create Pivot Tables in Excel
SUMIF Function In Excel
Lookup Function in Excel
Consolidate Data in Excel
Count Functions In Excel
COUNTIF function in Excel
Goal Seek in Excel
SubTotal In Excel
Data validation in Excel
Customize Cell Name in Excel
Drop Down List in MS Excel
Data Entry Through Form In Excel
Feature of Excel table
Custom Data validation In MS Excel
INDEX and MATCH Function In Excel
Indirect Function in Excel
Create Macro in Excel VBA Lesson-1
Input and Out Put in Excel VBA (Excel Macro) Lesson-2
ActiveCell Property and Methods in Excel VBA (Excel Macro) Lesson-2
How We Get Auto Serial Number in Excel.
Excel VBA Cell, Rows and Column Function
WorkSheets and Sheets object in Excel VBA
IF Statement and Worksheet cell Change Event
Nested IF Statement and Worksheet cell Change Event
FOR LOOP in Excel VBA Macro programming
For Each Loop In Excel VBA Macro Programming
Do Until, While, Do While Loop In Excel VBA
Simple User Form For Data Entry in EXCEL VBA
VBA Form In Excel