Create drop down list only if another cell's value indicates so

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.

Thanks for the help. I have attached a sample file here. The conditions and values are essentially the same as in my earlier post; only the cell addresses are different.

If Option 1 (cell B2) is set to "Yes", the drop down values for Option 2 (cell B3) include both "Yes" & "No".
If Option 1 is set to "No", the only option in the drop down list for Option 2 is "No."
If both Options were set to "Yes" and then Option 1 is changed from "Yes" to "No", I want the value in Option 2 to change automatically to "No".

Option 2's drop down values are listed in the table starting at cell H2.

Thanks again!

Here is an update that uses a macro to do this. However, if your example is greatly simplified compared to your actual problem the code will have to be revised to match.

That's all I needed. Thanks!

I should be able to make any necessary revisions.