change the data validation to 'any value if 'other' is selected
When the user hits the 'other' option in my drop down box, I would like the
data validation to be reset to any value or a pop-up is displayed that allows
them to enter the correct data and I populate the cell and the data
validation allows it to take
|