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