In cell A1 I can choose between apples, pears, oranges. When I choose apples than I have to write a number in B1 but when I choose pears I have to write a number in C1 and for oranges in D1.
Is it possible that when I choose apples automatically cell C1 and D1 get blocked from writing and when I choose pears the cell B1 and D1 will get blocked?