Hi,
I have two cells (B2 & C2), both with drop down lists. The drop down list in C2 depends on the selection made in B2, this is all working fine. However, there is one extra step I need to add and I'm not sure how to do it.
The list in B2 has an option "Other", when this is selected the user should be able to free type into C2 to specify their choice. However, with the data validation already active in C2 it won't allow this free typing.... How can we fix this? Is there a formula I can add to conditional formatting or something? Spreadsheet attached.
Thanks,
Willge
Bookmarks