Data Validations contingent on each other

C

cathy

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

Transfer data between two tables 3
Data Validation Question 2
How to do an IF statement that copy data based on a partial match 0
data validation defaults 2
checkbox problem 22
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
How to give count of lines before all 5 values pass?? 18
Complex IF statement 7

Top