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!!
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks