Data Validation Question

[cathy]

In cell $E$72 I have a data validation drop down list allowing the user to
select "blank" or 1% -10%. However if cell$D$15 reads "Affiliate" I want
cell $E$72 to default to " " or Blank. How can I do this?

 

[dan dungan]

Hi Cathy,

What formula are you using in your validation criteria?

Dan Dungan

 

[cathy]

I am using the list feature. Cell $E$72 is set up to allow the user to
select either blank or anywhere from 1% - 10%. However, if someone selects
"Affiliate" from the list in cell $D$15, I want cell $E$72 to default to
blank.