Can different drop down lists be displayed depending on the value.
 

Can different drop down lists be displayed depending on the value of another
reference cell?
for example, if A1 = true, then B1 displays drop down list #1, and if A1 =
FALSE, then B1 displays drop down list#2
Thanks for any tip!!

There are instructions here for dependent data validation lists:

http://www.contextures.com/xlDataVal02.html

Or, if you only have two choices, you could use an IF formula for the
list, e.g.:

=IF(E3="Yes",List1,List2)

Laurentd wrote:
Can different drop down lists be displayed depending on the value of another
reference cell?
for example, if A1 = true, then B1 displays drop down list #1, and if A1 =
FALSE, then B1 displays drop down list#2
Thanks for any tip!!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html