Forum Discussion
cmaly
Jul 15, 2020Brass Contributor
Sharepoint List Edit Form Conditional Formatting for Yes/No field
Hi, I have been able to successfully add conditional formatting to my columns in my Edit form based on the Microsoft link below. However, I can't get it to work for a Yes/No column. I have used th...
- Jul 22, 2020
Thank you for your response. I was unable to make it work with my column as it was. I tested on a Test Sharepoint list that I have and confirmed it was the name of my column causing me trouble. So I ended up creating a new Yes/No column that the naming did not have the x0020 between the words and now it is working fine.
Thanks again!
TechP3
Jun 12, 2022Copper Contributor
Appreciate this is an old post but if it helps anyone, I had an issue today where one list column type was set to Yes/No, and enabling 'Format yes and no' correctly applied red shading to no, and green to yes. However, an adjacent column was a formula which also returned a Yes/No value but the formatting would not apply.
To resolve this I did following:
1) Copied the JSON from the column that was working (Column settings / Format this column / Format yes and no - Advanced mode)
2) Pasted the JSON into the column that didn't work (can also paste it direct into the field within the list settings) and change the words true to "Yes" and false to "No". Note that it did not work without the quotation marks.