Here is what I am hoping to achieve: If "No" However, if the user selects, "Yes", then the remainder of the cells shall remain available to enter data into.Īll cells within each range have data entered via dropdowns only. If the user selects "No", then I wish to lock the remainder of the range of questions (G13-H13:AB13) as there is no need to enter data here. I have updated my example to reflect this.
The "Yes/No" cell is, in fact, a merge of two cells (G13 & H13).
Is it possible to lock a particular range of cells based on the input from a dropdown in a row of data?įor example, each row of my spreadsheet represents a patient, and the first cell asks a question, to which a "Yes" or "No" response is required (which is selected/entered via a dropdown).
0 kommentar(er)
