Forum Discussion
Conditonal Formatting Works for "No" but not "Yes"
Hey everyone, I have a spreadsheet tracking responses and in my final column (L) I can toggle between Yes and No. When No is selected there is no color change to the row but when Yes is selected ...
You mention that =$L3="no" works. Should the other formula perhaps be =$L3="yes" with lower case y?
Or could there be a space before or after Yes in column L?
- Hans, I will DM you with the file. Doesn't seem to accept the attachment on this thread.
Activate the Data Validation sheet.
There is a space after the word Yes in cell L3. This causes the conditional formatting rule to fail.
If you remove the space from L3, it'll work as intended.
Andrew reported in a private message that this solved his problem.
