Conditional Drop Down List

[rguliuzza]

I have a spreadsheet where cell "D29" can either be "YES" or "NO." I have a drop down list in cell "D30" to enter three options. What I would like to do on this protected sheet is if Cell "D29" is "NO," the drop down list is locked, otherwise it can be chosen.

Any ideas?

Best regards,
Rick

 

[LxQ]

in the data validation window in the Source field you key in:
=IF(D29="yes",$F$33:$F$35,$F$36:$F$37)

where $F$33:$F$35 was where I put three possible selections in case D29 is yes and $F$36:$F$37 were empty cells.. maybe one cell would work too.. and I think "Ignore blank" should also be checked

 

[rguliuzza]

Thank you, that was the ticket!

Best regards,
Rick