for example, if cell A1=0, then A2 shows drop down list #1, if not, A2 shows
a different dropdown list#2

All you need to know about Data Validation drop down lists can be found at
this site of Debra Dalgleish:

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

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Laurent" wrote in message
...
for example, if cell A1=0, then A2 shows drop down list #1, if not, A2 shows
a different dropdown list#2