Data Validation w/an If Statement

S

Steve

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
IF statement reference 1
How to make repeating drop-down lists? 2
Create two Data validation lists that are linked(Both change toget 2
Drop down list control value in vba 2
Using Drop Down list to an If Statement to another Drop Down list 3
A data validation question 1
Multiple IF Statement in Word 5

Top