Forum Discussion
Flagging an empty in a cell, if another cell contains a value
Two part question: FIRST I'm trying to highlight red, via conditional formatting, cases in which a survey respondent answered "other" in a multiple choice question, but didn't add an answer t...
FIRST
Can you make the formulas in columns C to L return the number 1 (without quotes) instead of the text value "1"?
If so, your conditional formatting should work.
If it is not possible, change the conditional formatting formula to =AND(L4="1",M4="")
SECOND
Use the same formula that you use for conditional formatting. Or am I missing something?