Data Validations contingent on each other

G

Guest

I have two data validation list cells - cell $D$15 (has the option of blank
or "affiliate") and cell $E$72 (has the option of blank or 1% - 10%).

When cell $D$15 is blank, there are no restrictions on cell $E$72. However,
when cell $D$15 is "affiliate", I want cell $E$72 to default to blank & not
allow any other options. How can I accomplish this? Thanks.
 

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

Data Validation Question 2
data validation defaults 2
Complex IF statement 7
Establishing a default on dependent data validation lists 4
Emailing from cells 1
Multiple Conditional Formatting 3
Data Validation - Drop down when cell is blank 1
Data Validation 2

Top