Forum Discussion
AndrewC1991
Mar 31, 2022Copper Contributor
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 ...
AndrewC1991
Mar 31, 2022Copper Contributor
Hans, I will DM you with the file. Doesn't seem to accept the attachment on this thread.
HansVogelaar
Mar 31, 2022MVP
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.
- HansVogelaarMar 31, 2022MVP
Andrew reported in a private message that this solved his problem.