SOLVED

SharePoint List View Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1002990%22%20slang%3D%22en-US%22%3ESharePoint%20List%20View%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1002990%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20conditionally%20format%20a%20view%20by%20highlighting%20the%20entire%20list%20row%20when%20a%20column%20called%20'Contracts%20Read'%20(Contracts_x0020_Read)%20is%20equal%20to%20No.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIdeally%20I%20would%20like%20to%20make%20the%20list%20row%20bold%2C%20or%20highlight%20it%20red.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20column%20is%20a%20Yes%2FNo%20checkbox%2C%20and%20I%20only%20want%20to%20apply%20this%20to%20one%20view.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1002990%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1003322%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20View%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1003322%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359684%22%20target%3D%22_blank%22%3E%40Sam1209%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20an%20example%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F156577iA5ED133C00080B0E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3E%7B%3CBR%20%2F%3E%22schema%22%3A%20%22https%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fview-formatting.schema.json%22%2C%3CBR%20%2F%3E%22additionalRowClass%22%3A%20%22%3Dif(%5B%24ContractsRead%5D%20%3D%3D%20false%2C%20'sp-field-severity--blocked'%2C%20'')%22%3CBR%20%2F%3E%7D%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBe%20sure%20to%20update%26nbsp%3B%3CSTRONG%3E%24ContractsRead%3C%2FSTRONG%3E%20to%20%24%3CSPAN%3E%3CSTRONG%3EContracts_x0020_Read%3C%2FSTRONG%3E.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20hope%20this%20helps.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ENorm%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

I need to conditionally format a view by highlighting the entire list row when a column called 'Contracts Read' (Contracts_x0020_Read) is equal to No. 

 

Ideally I would like to make the list row bold, or highlight it red.

 

This column is a Yes/No checkbox, and I only want to apply this to one view.

 

Any help would be appreciated.

1 Reply
Best Response confirmed by Sam1209 (Contributor)
Solution

Hi @Sam1209,

 

Here is an example:

clipboard_image_0.png

 

{
"schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
"additionalRowClass": "=if([$ContractsRead] == false, 'sp-field-severity--blocked', '')"
}

 

Be sure to update $ContractsRead to $Contracts_x0020_Read.

 

I hope this helps.

 

Norm