Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation w/an If Statement
Is it possible to use the Data Validation function with an if statement; then
if the if statement is false limit the input value based on a drop down list? Example: A1 can have any value B1 is where I want the Data Validation with an if statement to look at A1: If A1 has a particular value (e.g., APPLE), then I would like B1 populated with APPLE; however, if A1 does not equal APPLE, then I would like B1 limited to three values the user can select from a drop down menu (e.g., RED, BLUE, or GREEN). Any ideas would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation w/an If Statement
Hi Steve,
Take a look to Debra web dependent lists http://www.contextures.com/xlDataVal02.html#TwoWord "Steve" wrote: Is it possible to use the Data Validation function with an if statement; then if the if statement is false limit the input value based on a drop down list? Example: A1 can have any value B1 is where I want the Data Validation with an if statement to look at A1: If A1 has a particular value (e.g., APPLE), then I would like B1 populated with APPLE; however, if A1 does not equal APPLE, then I would like B1 limited to three values the user can select from a drop down menu (e.g., RED, BLUE, or GREEN). Any ideas would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional statement using validation cell | Excel Worksheet Functions | |||
Data Validation w/If Statement | Excel Worksheet Functions | |||
Validation in a Conditional Statement | Excel Worksheet Functions | |||
If statement with validation list | Excel Worksheet Functions | |||
How do I use a conditional (IF) statement in Data Validation? | Excel Worksheet Functions |