Greetings,

I am wondering if it is possible to include drop down lists if an earlier cell dictates so but override to a set value if not. For example, if cell A1 says "Yes", then cell B1 has a drop down menu giving an additional Yes/no option; if cell A1 says "no", then B1 will adjust to also saying "no."

I know how to set up the lists such that the selection in A1 changes the available values in B1's drop down menu, however, if both A1 & B1 were at one point set to "yes", changing A1's value does not automatically change the value in B1, it simply changes the options for editing the cell. I want to avoid a situation where a user inadvertently adjusts some but not all values.

Thanks in advance for your help.