ihave a dropdown box in a cell and i want to make that cell blank based on value of another cell

Occasional Visitor

a18 to a28 ihave dropdown box in cells when a vale is selected in a17 the drop down list changes . if I enter vale"other " in a17 . all dropdown boxes in cells a18 to a 28 should be blank I mean a blank cell without drop down box

0 Replies