Conditional Data Validation??

[Iceberg]

Hello,

I am using the Data Validation feature to create in-cell drop-down menus.

Is it possible to have drop-downs menu in both Cell A and Cell B, where the choices in Cell B's menu depend on the choice selected in Cell A?

For instance, Cell A has "Pizza" and "Hamburgers" as choices in the drop-down. If you select "Pizza", the drop-down in Cell B offers the choices "Pepperoni" and "Mushrooms". If, however, you select "Hamburgers" in Cell A, the drop-down in Cell B is now populated with "Ketchup" and "Mustard".

Is this possible??

 

[Datsmart]

Answered here:
http://www.mrexcel.com/forum/showthread.php?t=231696