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.

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.
>