Changing First dropdown list affects the first selcted value in Second dropdown List

Hello All,

I have an excel sheet where I have 3 dropdown lists:

The first one (A) have value 0 or 1 for example
Second one (B) has a list of elements
Third one (C) Has the same list of (B)
I have a condition to respect :

If (A)=0 both dropddown (B) and (C) should show the same selection list .
If (A)=1 DropDown (B) should show the normal list but dropdown (C) should show the same selected value in (B) and only the selected value ( Do not show all the other list values).
I tried using this condition on the (C) dropdown cell using Data validation :

Please Login or Register  to view this content.

But the problem comes up when I select value1 for example in Dropdown C and then change the selection of A=0 to A=1 , and then I select in B Value2 , The Dropdown C still shows Value1 but when I click on it , I find in the list only Value2 ( but what it shows is Value1 eventhough it is not selected).

How can I solve this situation ? and directly show the correct value in C ? ( Preferebly without using VBA)

Thank you