Hi All,
I am trying to use conditional formatting to highlight cells if two conditions are met. On my spreadsheet, I am asking the question "Have you completed this worksheet?" and if the person chooses "yes" from the drop down menu in cell C2 then I want all the blank cells within E8:L19 to highlight yellow alerting the participant that they neglected to answer some of the questions.
Thanks in advance!
I am trying to use conditional formatting to highlight cells if two conditions are met. On my spreadsheet, I am asking the question "Have you completed this worksheet?" and if the person chooses "yes" from the drop down menu in cell C2 then I want all the blank cells within E8:L19 to highlight yellow alerting the participant that they neglected to answer some of the questions.
Thanks in advance!