Excel -- Data Validation -- Validation Criteria Examples
Whole Number Decimal List Date Time Text Length

Whole Number Set or exclude a range of numbers, or specify a minimum or maximum. Type values into the Data Validation dialog box, OR Refer to cells on the worksheet, OR Use formulas to set the values
Decimal Set or exclude a range of numbers, or specify a minimum or maximum. Type values into the Data Validation dialog box, OR Refer to cells on the worksheet, OR Use formulas to set the values
List See examples here: Data Validation
Date Set or exclude a range of dates, or specify a minimum or maximum. Type dates into the Data Validation dialog box, OR Refer to cells on the worksheet, OR Use formulas to set the dates In this example, the current date is the Start date, and 7 days from the current date is the End date:

Time Set or exclude a range of times, or specify a minimum or maximum. Type times into the Data Validation dialog box, OR Refer to cells on the worksheet, OR Use formulas to set the times The formula in this example uses the current time as an end time:

=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))

Text Length Set or exclude a range of lengths, or specify a minimum or maximum. Type length into the Data Validation dialog box, OR Refer to cells on the worksheet, OR Use formulas to set the length

1. Data Validation 2. Data Validation -- Create Dependent Lists 3. Hide Previously Used Items in a Dropdown List 4. Display Messages to the User 5. Use a List from Another Workbook 6. Validation Criteria Examples 7. Custom Validation Criteria Examples 8. Data Validation Tips 9. Data Validation Documentation    10 Data Validation -- Combo box      11. Data Validation -- Combo Box - Named Ranges 12. Data Validation -- Display Input Messages in a Text Box  13. Data Validation -- Dependent Dropdowns from a Sorted List

Home     Excel Tips     Excel Files      Blog    Contact
		The Excel Store	Debra Dalgleish