FatalLordes
New Member
- Joined
- Dec 22, 2017
- Messages
- 49
Okay, I think this SHOULD be simple but I can't get my head around it.
Here is a sample table:
So I've worked out how to get a drop down list allowing Yes or No, but my first question is how to NOT allow no answer. For example, the cell MUST contain either a Yes or No or you can't exit cell.
My second question is, using the sample table above, if an answer in a cell for Column D equals "No", then change whatever was entered on the same row but in Column A to "Yes", regardless if it was a Yes or No in there. For example, in Row 2, because No was entered in Column D, then A2 would be changed to Yes.
Hoping someone can help on either or even both questions
Thank you in advance
Here is a sample table:
A | B | C | D | |
1 | Yes | No | Yes | No |
2 | No | Yes | Yes | No |
So I've worked out how to get a drop down list allowing Yes or No, but my first question is how to NOT allow no answer. For example, the cell MUST contain either a Yes or No or you can't exit cell.
My second question is, using the sample table above, if an answer in a cell for Column D equals "No", then change whatever was entered on the same row but in Column A to "Yes", regardless if it was a Yes or No in there. For example, in Row 2, because No was entered in Column D, then A2 would be changed to Yes.
Hoping someone can help on either or even both questions