Make Drop Down Menu Default to One Value dependant on another cell

I have a drop down menu in cell C12, using the List function under Data Validation. The menu only has two options, Y and N

Now is there a way to make this menu default to N if the value in cell B10 is "1" and then revert back to the drop down menu offering Y and N if the cell B10 contains "2" ?

thanks

Hello
The following formula, entered in the data validation list source, should do the trick. I used define name to set range No (One cell with
value set to "N") and range Both (two cells with value "N" and value "Y". At present, the drop-down won't populate unless B10 = 1 or 2.

=IF(B10=1, No, IF(B10=2, Both, ""))

HTH

that works great, thanks

i dont know if this is possible, at the moment as it works, i select 1 in B10 and in the drop down menu it shows 'N' as the only option to choose. But if Y was the last option chosen that still shows in the cell until you select the drop down menu and pick N. Is there any way to sort of refresh the spreadsheet once you select '1' on B10 so that automatically at that point, the drop down menu cell shows 'N' without it being selected? thanks