Sharepoint Conditional Formatting

Hi All, I am trying to find Json code for SharePoint online 365 columns in a custom list: If columnX = "no" make the column bold TIA, Joe

developer

sharepoint 365

Joe Fischer
Jan 31, 2018
Hi Nigel,

Yes a small bit of Json in the column formatting does the trick :)

Below is an example, @faustocapellanjr sent me...

Thanks again for your help.

Joe

{
   "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json",
   "txtContent": "@currentField",
   "elmType": "div",
   "style": {
       "font-weight": {
           "operator": "?",
           "operands": [
               {
                   "operator": "==",
                   "operands": [
                       "@currentField",
                       "No"
                   ]
               },
               "bold",
               ""
           ]
       }
   }
}

Matthew DiLiberto

Brass Contributor

Jan 27, 2019

Rather than making a column bold, you may be able to achieve the same business requirement and draw attention to a value by changing the background color. This can be conditional set based on the value on a record (i.e Yes or No).

More recently, there is also a no-code solution for Choice, Date/Time, and Boolean column types that does not require knowledge of complex JSON to assign background colors.

https://www.technologytobusiness.com/microsoft-sharepoint/no-code-column-formatting-sharepoint-online

Joe Fischer

Brass Contributor

Jan 28, 2019

Hi matthew,

That is wonderful!!!

Thank you so much for keeping track of this issue and responding!!

Thanks Agian,

Joe