I have a situation where I have 2 questions that I want to ask users of my spreadsheet, the answer is yes or no. I have provided a data validation list box for selection of Yes or No. The default answer for these questions is no.
What I am looking for is a range of Cells G28:I33 to be grayed out and locked to user input when question 1 is No and have a data validation list box and be unlocked to user input if Question 1 is Yes.
The same would apply to Question 2 but I assume the formatting would be the same.
I have attached an example file with desired outcomes and the data validation. In the desired outcome example, I would like the desired outcomes to be there when the cells become active to user input.
Any help would be appreciated
Bookmarks