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

Related Conversations
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
PWA fullscreen like IE11 kiosk mode
rogihee in Discussions on
5 Replies
Excel ComboBox (ActiveX Controls) dropdown not functioning
Kpizzle in Excel on
1 Replies
if then formula help
BMARSH99 in Excel on
1 Replies