Mar 31 2022 09:56 AM - edited Mar 31 2022 10:43 AM
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 the entire row is supposed to turn green.
The formula used is =$L3="Yes"
The problem is when you toggle to Yes there is no color change. I changed the formatting to =$L3="no" to give that a try and it worked.
Has anyone run into this issue before where the formatting works for one and not the other?
Its driving me nuts and I have spent so much time trying to figure it out.
Mar 31 2022 11:30 AM
@AndrewC1991 Difficult to help without seeing what you exactly have down. Perhaps the attached file can help you resolve the problem.
Mar 31 2022 11:30 AM
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?
Mar 31 2022 11:42 AM - edited Mar 31 2022 11:45 AM
I have attached an example here. I had to remove some columns for privacy. You will notice in column J, when you toggle to NO the entire row goes red but when you toggle to yes nothing changes. I have the formatting set for both No and Yes in this example.
Thoughts?
Mar 31 2022 11:48 AM
@AndrewC1991 I see no attachment.
Mar 31 2022 12:05 PM
Mar 31 2022 12:27 PM
Mar 31 2022 01:39 PM
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.
Mar 31 2022 02:58 PM
Andrew reported in a private message that this solved his problem.