Column conditional format with Json to display attention colour if column is blank

%3CLINGO-SUB%20id%3D%22lingo-sub-179405%22%20slang%3D%22en-US%22%3EColumn%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-179405%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Devs%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20need%20your%20help.%20I%20cannot%20for%20the%20life%20of%20me%20figure%20out%20how%20to%20tweak%20this%20Json%20schema%20provided%20by%20Microsoft%20in%20order%20to%26nbsp%3Bformat%20a%20column%20to%20simple%20display%20an%20attention%20or%20warning%20colour%20if%20a%20field%20in%20the%20column%20is%20blank%2Fnull%2Funpopulated.%20Same%20way%20the%20default%26nbsp%3BSharePoint%20'%20required%20info'%20attention%20banner%20behaves%20for%20missing%20mandatory%20fields%20library.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20kindly%20help.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%7B%0A%20%20%20%20%22%24schema%22%3A%20%22http%3A%2F%2Fcolumnformatting.sharepointpnp.com%2FcolumnFormattingSchema.json%22%2C%0A%20%20%20%20%22debugMode%22%3A%20true%2C%0A%20%20%20%20%22elmType%22%3A%20%22div%22%2C%0A%20%20%20%20%22attributes%22%3A%20%7B%0A%20%20%20%20%20%20%20%22class%22%3A%20%7B%0A%20%20%20%20%20%20%20%20%20%20%22operator%22%3A%20%22%3F%22%2C%0A%20%20%20%20%20%20%20%20%20%20%22operands%22%3A%20%5B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22operator%22%3A%20%22%26lt%3B%3D%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22operands%22%3A%20%5B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22%40currentField%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%2070%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5D%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%22sp-field-severity--warning%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%22%22%0A%20%20%20%20%20%20%20%20%20%20%5D%0A%20%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%2C%0A%20%20%20%20%22children%22%3A%20%5B%0A%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22elmType%22%3A%20%22span%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22style%22%3A%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22display%22%3A%20%22inline-block%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22padding%22%3A%20%220%204px%22%0A%20%20%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22attributes%22%3A%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22iconName%22%3A%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22operator%22%3A%20%22%3F%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22operands%22%3A%20%5B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22operator%22%3A%20%22%26lt%3B%3D%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22operands%22%3A%20%5B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22%40currentField%22%2C%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%2070%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5D%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22Error%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%22%22%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%5D%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%20%20%20%20%7D%2C%0A%20%20%20%20%20%20%20%20%7B%0A%20%20%20%20%20%20%20%20%20%20%20%20%22elmType%22%3A%20%22span%22%2C%0A%20%20%20%20%20%20%20%20%20%20%20%20%22txtContent%22%3A%20%22%40currentField%22%0A%20%20%20%20%20%20%20%20%7D%0A%20%20%20%20%5D%0A%7D%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-393588%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393588%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20you%20help%20me%20if%20I%20would%20like%20to%20highlight%20cell%201A%20(in%20column%20A)%26nbsp%3B%20if%20cell%201B%20(in%20column%20B)%20is%20blank%3F%3C%2FP%3E%3CP%3EAs%20I%20believe%20the%20code%20you%20gave%20is%20for%20the%20same%20column%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F130872%22%20target%3D%22_blank%22%3E%40Jeremiah%20Benjamin%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-363895%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-363895%22%20slang%3D%22en-US%22%3E%3CP%3ENice!%3C%2FP%3E%3CP%3EAlmost%20what%20I've%20been%20trying%20to%20do%20but%20would%20it%20also%20be%20possible%20to%20display%20an%20alternative%20text%20in%20the%20colored%20blank%20fields%20eg%20%22Use%20default%20value%22%3F%3C%2FP%3E%3CP%3EI'm%20trying%20to%20do%20this%20for%20a%20date%20field%20so%20I%20can't%20add%26nbsp%3B%22Use%20default%20value%22%20as%20the%20default%20cell%20value%20for%20the%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304696%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304696%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20works%20perfectly%20!%26nbsp%3B%3CBR%20%2F%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304685%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304685%22%20slang%3D%22en-US%22%3E%3CP%3EI%20haven't%20tried%20that%2C%20but%20I'm%20guessing%20you%20can%20take%20these%20lines%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%23FF0000%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20switch%20them%20around%20like%20so%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%23FF0000%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%5D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-304574%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-304574%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20i%20wanted%20to%20do%20the%26nbsp%3Bopposite%2C%20display%20a%20color%20only%20if%20there%20is%20a%20value%20in%20the%20column.%3CBR%20%2F%3EHow%20would%20that%20look%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-298956%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-298956%22%20slang%3D%22en-US%22%3E%3CP%3EYes%2C%20you%20can!%26nbsp%3B%20Microsoft%20has%20posted%20a%20nice%20example%20of%20that%20here%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FColumn-formatting-1f927342-2bed-4745-b727-ff8b7ff96b22%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FColumn-formatting-1f927342-2bed-4745-b727-ff8b7ff96b22%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F171685%22%20target%3D%22_blank%22%3E%40Bibhu%20Panigrahi%3C%2FA%3Eis%20also%20doing%20something%20like%20that%20further%20up%20in%20this%20post%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FSharePoint-Developer%2FColumn-conditional-format-with-Json-to-display-attention-colour%2Fm-p%2F270403%2Fhighlight%2Ftrue%23M5738%22%20target%3D%22_self%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-298931%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-298931%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20give%20more%20values%20a%20color%2C%20instead%20of%20just%20one%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-292706%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292706%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20very%20close%20to%20what%20I%20want%20but%20would%20love%20to%20apply%20a%20bunch%20of%20formatting%20if%20a%20cell%20is%20not%20blank%20rather%20than%20just%20one%20particular%20style.%26nbsp%3B%20I'm%20struggling%20with%20the%20operator%2Foperands%20syntax%20for%20applying%20a%20bunch%20of%20styles%20to%20the%20child%20element%20if%20the%20field%20is%20not%20blank.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20formatting%20that%20I%20would%20like%20but%20without%20formatting%20the%20blanks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%22%24schema%22%3A%20%22%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fcolumn-formatting.schema.json%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fcolumn-formatting.schema.json%3C%2FA%3E%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%22elmType%22%3A%20%22div%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%22children%22%3A%20%5B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%7B%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%22elmType%22%3A%20%22div%22%2C%3CBR%20%2F%3E%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%22txtContent%22%3A%20%22%40currentField%22%2C%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%22style%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%22background-color%22%3A%20%22%23ffffe0%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%22text-wrap%22%3A%20%22wrap%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%22font-size%22%3A%20%2212px%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%22font-weight%22%3A%20%22bold%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%22padding%22%3A%20%224px%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%22border-style%22%3A%20%22solid%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%22border-width%22%3A%20%222px%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%22border-color%22%3A%20%22%23ffff00%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%7D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%7D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%5D%3CBR%20%2F%3E%7D%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-279143%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279143%22%20slang%3D%22en-US%22%3E%3CP%3EI%20forgot%20to%20mention%20--%20to%20make%20it%20work%20for%20non-text%20Columns%2C%20convert%20the%20value%20to%20a%20string%20before%20evaluating%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%7B%3CBR%20%2F%3E%26nbsp%3B%20%22%24schema%22%3A%20%22%3CA%20href%3D%22http%3A%2F%2Fcolumnformatting.sharepointpnp.com%2FcolumnFormattingSchema.json%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fcolumnformatting.sharepointpnp.com%2FcolumnFormattingSchema.json%3C%2FA%3E%22%2C%3CBR%20%2F%3E%26nbsp%3B%20%22elmType%22%3A%20%22div%22%2C%3CBR%20%2F%3E%26nbsp%3B%20%22txtContent%22%3A%20%22%40currentField%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22style%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22background-color%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operator%22%3A%20%22%3F%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operands%22%3A%20%5B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operator%22%3A%20%22%3D%3D%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operands%22%3A%20%5B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operator%22%3A%20%22toString()%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operands%22%3A%20%5B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%40currentField%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%5D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%5D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%23FF0000%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%5D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%7D%3CBR%20%2F%3E%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F171685%22%20target%3D%22_blank%22%3E%40Bibhu%20Panigrahi%3C%2FA%3E!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-279130%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-279130%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20this%20--%20I%20needed%20to%20highlight%20any%20empty%20column%20values%20in%20bright%20red.%26nbsp%3B%20I%20modified%20your%20JSON%20to%20this%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%7B%3CBR%20%2F%3E%26nbsp%3B%20%22%24schema%22%3A%20%22%3CA%20href%3D%22http%3A%2F%2Fcolumnformatting.sharepointpnp.com%2FcolumnFormattingSchema.json%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fcolumnformatting.sharepointpnp.com%2FcolumnFormattingSchema.json%3C%2FA%3E%22%2C%3CBR%20%2F%3E%26nbsp%3B%20%22elmType%22%3A%20%22div%22%2C%3CBR%20%2F%3E%26nbsp%3B%20%22txtContent%22%3A%20%22%40currentField%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22style%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22background-color%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operator%22%3A%20%22%3F%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operands%22%3A%20%5B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operator%22%3A%20%22%3D%3D%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operands%22%3A%20%5B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%40currentField%22%2C%20%22%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%5D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%23FF0000%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%5D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%7D%3CBR%20%2F%3E%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20it%20works%20perfectly%20for%20what%20I%20need!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270403%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270403%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Silas%2C%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20just%20get%20a%20specific%20background-color%20in%20the%20cell%20depending%20on%20the%20value%20of%20that%20column%2C%20you%20can%20use%20something%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%22%24schema%22%3A%20%22%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fcolumn-formatting.schema.json%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fcolumn-formatting.schema.json%3C%2FA%3E%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%22elmType%22%3A%20%22div%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%22txtContent%22%3A%20%22%40currentField%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%22style%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22background-color%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operator%22%3A%20%22%3F%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operands%22%3A%20%5B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operator%22%3A%20%22%3D%3D%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22operands%22%3A%20%5B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%40currentField%22%2C%20%22High%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%5D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%3CSPAN%3E%23FFA07A%3C%2FSPAN%3E%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%5D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%20%7D%3CBR%20%2F%3E%7D%3C%2FP%3E%3CP%3EI%20have%20used%26nbsp%3Bthe%20above%20code%20successfully%20to%26nbsp%3Bdisplay%20the%20Priority%20column%20in%20red%26nbsp%3Bif%20the%20value%20is%20'High'.%20The%20JSON%20example%20you%20have%20quoted%20is%20needed%20if%20you%20want%20to%26nbsp%3Bdisplay%20the%20pre-configured%20icons%20as%20well%2C%20like%20what%20I%20have%20used%20here%3A%3C%2FP%3E%3CP%3E%7B%3CBR%20%2F%3E%26nbsp%3B%20%22%24schema%22%3A%20%22%3CA%20href%3D%22https%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fcolumn-formatting.schema.json%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdeveloper.microsoft.com%2Fjson-schemas%2Fsp%2Fcolumn-formatting.schema.json%3C%2FA%3E%22%2C%3CBR%20%2F%3E%26nbsp%3B%20%22debugMode%22%3A%20true%2C%3CBR%20%2F%3E%26nbsp%3B%20%22elmType%22%3A%20%22div%22%2C%3CBR%20%2F%3E%26nbsp%3B%20%22attributes%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22class%22%3A%20%22%3Dif(%40currentField%20%3D%3D%20'Completed'%2C%20'sp-field-severity--good'%2C%20if(%40currentField%20%3D%3D%20'In%20Progress'%2C%20'sp-field-severity--low'%20%2Cif(%40currentField%20%3D%3D%20'Not%20Started'%2C'sp-field-severity--warning'%2C%20if(%40currentField%20%3D%3D%20'Deferred'%2C'sp-field-severity--blocked'%2C%20''))%22%3CBR%20%2F%3E%26nbsp%3B%20%7D%2C%3CBR%20%2F%3E%26nbsp%3B%20%22children%22%3A%20%5B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22elmType%22%3A%20%22span%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22style%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22display%22%3A%20%22inline-block%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22padding%22%3A%20%220%204px%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22attributes%22%3A%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22iconName%22%3A%20%22%3Dif(%40currentField%20%3D%3D%20'Completed'%2C'CheckMark'%2C%20if(%40currentField%20%3D%3D%20'In%20Progress'%2C%20'Forward'%2C%20if(%40currentField%20%3D%3D%20'Not%20Started'%2C%20'Error'%2C%20if(%40currentField%20%3D%3D%20'Deferred'%2C'Warning'%2C'')%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7B%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22elmType%22%3A%20%22span%22%2C%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%22txtContent%22%3A%20%22%40currentField%22%3CBR%20%2F%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%7D%3CBR%20%2F%3E%26nbsp%3B%20%5D%3CBR%20%2F%3E%7D%3C%2FP%3E%3CP%3ESee%20the%20attached%20image%20to%20view%20how%20the%20list%20appears.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-270390%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-270390%22%20slang%3D%22en-US%22%3E%3CP%3EDid%20you%20find%20a%20solution%20to%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-180337%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-180337%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Dean%2C%20I%20have%20seen%20those%20and%20they%20don't%20have%20anything%20close%20to%20what%20I'm%20after%20which%20I%20would%20have%20thought%20was%20more%20basic%20than%20most%20of%20the%20other%20samples%20provided%20by%20Microsoft%20and%20others.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20please%20help%20with%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-179420%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-179420%22%20slang%3D%22en-US%22%3E%3CP%3EHere%20are%20some%20more%20examples%20that%20may%20help%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-column-formatting%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-column-formatting%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633127%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633127%22%20slang%3D%22en-US%22%3EHi%20Jeremiah%2C%20this%20code%20of%20yours%20does%20exactly%20what%20I%20want%20except%20that%20for%20those%20list%20items%20containing%20an%20object%20(in%20my%20case%20users)%20it%20replaces%20the%20user%20name%20with%20the%20text%20string%20%5Bobject%20Object%5D%20any%20ideas%20on%20how%20to%20avoid%20that%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633166%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633166%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F116192%22%20target%3D%22_blank%22%3E%40Erik%20Wettergren%3C%2FA%3EI'm%20definitely%20no%20expert%20in%20this%2C%20sorry!%26nbsp%3B%20I%20just%20shared%20what%20worked%20(which%20I%20borrowed%20from%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F171685%22%20target%3D%22_blank%22%3E%40Bibhu%20Panigrahi%3C%2FA%3E%20and%20modified%20a%20bit%20by%20trial-and-error%20until%20I%20got%20what%20we%20needed).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20found%20a%20lot%20of%20good%20stuff%20here%3A%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-list-formatting%2Ftree%2Fmaster%2Fcolumn-samples%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-list-formatting%2Ftree%2Fmaster%2Fcolumn-samples%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThose%20samples%20are%20great%20starting%20points%2C%20hopefully%20you%20find%20something%20useful.%26nbsp%3B%20Good%20luck!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633173%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633173%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F313164%22%20target%3D%22_blank%22%3E%40nanuar%3C%2FA%3ESorry%20I%20missed%20this!%26nbsp%3B%20I%20have%20referenced%20column%20data%20from%201%20column%20and%20formatted%20a%202nd%20based%20on%20it%20in%20other%20SP%20Lists.%26nbsp%3B%20The%20downside%20is%20you%20have%20to%20display%20both%20columns%20in%20the%20View.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20get%20some%20good%20examples%20of%20how%20it%20all%20works%20here%3A%26nbsp%3B%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-docs%2Fissues%2F1250%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-docs%2Fissues%2F1250%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20of%20luck!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633181%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633181%22%20slang%3D%22en-US%22%3ETanks%2C%20will%20look%20into%20those%20examples!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-642872%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-642872%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F116192%22%20target%3D%22_blank%22%3E%40Erik%20Wettergren%3C%2FA%3E%2C%20I%20use%26nbsp%3B%22txtContent%22%3A%20%22%40currentField.title%22%20to%20get%20the%20user%20name%20instead%20of%20%3CSPAN%3E%5Bobject%20Object%5D%20in%20people%20columns.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F130872%22%20target%3D%22_blank%22%3E%40Jeremiah%20Benjamin%3C%2FA%3E%26nbsp%3B%2C%20thanks%20for%20tagging%20me%20to%20your%20response.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-643838%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-643838%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F171685%22%20target%3D%22_blank%22%3E%40Bibhu%20Panigrahi%3C%2FA%3E%20it%20works%20just%20fine!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20then%20the%20actual%20person%20object%20won't%20be%20displayd%20(i.e.%20no%20additional%20info%20available).%20But%20I%20guess%20that's%20asking%20for%20too%20much.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20the%20same%20with%20friendly%20date%20format%20-%20that%20doesn't%20work%20either%20when%20applying%20column%20formatting%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-649258%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-649258%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F116192%22%20target%3D%22_blank%22%3E%40Erik%20Wettergren%3C%2FA%3E%2C%20I%20agree%20there%20are%20still%20some%20limitations%20depending%20on%20the%20column%20type.%20Here%20are%20the%20attributes%20of%20a%20People%20column%20you%20can%20access%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116152i0932D01F096F1968%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22People-field-attributes.JPG%22%20title%3D%22People-field-attributes.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20got%20this%20from%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Fcolumn-formatting%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Fcolumn-formatting%3C%2FA%3E%2C%20which%20gives%20details%20of%20all%20the%20operands%20and%20attributes%20you%20can%20use%20in%20column%20formatting.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-651402%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-651402%22%20slang%3D%22en-US%22%3EThanks%20again%2C%20yeah%20that%20is%20a%20massive%20article%20with%20lots%20of%20tips.%20However%2C%20even%20if%20I%20can%20get%20for%20example%20%40currentField.title%20to%20work%20I%20fail%20when%20tryiong%20the%20same%20with%20%40currentField.picture%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1881298%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20conditional%20format%20with%20Json%20to%20display%20attention%20colour%20if%20column%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1881298%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20a%20not%20programmer%2C%20was%20looking%20for%20a%20bit%20of%20json%20that%20simply%20makes%20standard%20sharepoint%20black%20text%2C%20white%20(e.g.%20invisible)%20when%20a%20value%20is%20%26lt%3B0%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei.e.%20I%20have%20a%20now()%20date%20formula%20that%20runs%20off%20flow%2C%20but%20until%20it%20runs%2C%20the%20calc'ed%20field%20will%20display%20say%20-44300%20as%20it%20has%20no%20variable%20yet.%20This%20is%20just%20a%20cheet%20fix%20to%20not%20show%20the%20item.....%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi Devs,

 

I need your help. I cannot for the life of me figure out how to tweak this Json schema provided by Microsoft in order to format a column to simple display an attention or warning colour if a field in the column is blank/null/unpopulated. Same way the default SharePoint ' required info' attention banner behaves for missing mandatory fields library.

 

Please kindly help.

 

{
    "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json",
    "debugMode": true,
    "elmType": "div",
    "attributes": {
       "class": {
          "operator": "?",
          "operands": [
             {
                "operator": "<=",
                "operands": [
                   "@currentField",
                   70
                ]
             },
             "sp-field-severity--warning",
             ""
          ]
       }
    },
    "children": [
        {
            "elmType": "span",
            "style": {
                "display": "inline-block",
                "padding": "0 4px"
            },
            "attributes": {
                "iconName": {
                    "operator": "?",
                    "operands": [
                        {
                            "operator": "<=",
                            "operands": [
                                "@currentField",                  
                                70
                            ]
                        },
                        "Error",
                        ""
                    ]
                }
            }
        },
        {
            "elmType": "span",
            "txtContent": "@currentField"
        }
    ]
}

 

23 Replies

Thanks Dean, I have seen those and they don't have anything close to what I'm after which I would have thought was more basic than most of the other samples provided by Microsoft and others.

 

Can anyone please help with this?

Hi Silas,

If you want to just get a specific background-color in the cell depending on the value of that column, you can use something like this:

 

{
   "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
   "elmType": "div",
   "txtContent": "@currentField",
   "style": {
      "background-color": {
         "operator": "?",
         "operands": [
            {
               "operator": "==",
               "operands": [
                 "@currentField", "High"
                  ]
            },
            "#FFA07A",
            ""
         ]
      }
   }
}

I have used the above code successfully to display the Priority column in red if the value is 'High'. The JSON example you have quoted is needed if you want to display the pre-configured icons as well, like what I have used here:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "debugMode": true,
  "elmType": "div",
  "attributes": {
    "class": "=if(@currentField == 'Completed', 'sp-field-severity--good', if(@currentField == 'In Progress', 'sp-field-severity--low' ,if(@currentField == 'Not Started','sp-field-severity--warning', if(@currentField == 'Deferred','sp-field-severity--blocked', ''))"
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "display": "inline-block",
        "padding": "0 4px"
      },
      "attributes": {
        "iconName": "=if(@currentField == 'Completed','CheckMark', if(@currentField == 'In Progress', 'Forward', if(@currentField == 'Not Started', 'Error', if(@currentField == 'Deferred','Warning','')"
      }
    },
    {
      "elmType": "span",
      "txtContent": "@currentField"
    }
  ]
}

See the attached image to view how the list appears.

 

 

 

Thanks for this -- I needed to highlight any empty column values in bright red.  I modified your JSON to this: 

 

{
  "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json",
  "elmType": "div",
  "txtContent": "@currentField",
     "style": {
      "background-color": {
         "operator": "?",
         "operands": [
            {
               "operator": "==",
               "operands": [
                 "@currentField", ""
                  ]
            },
            "#FF0000",
            ""
         ]
      }
   }
}

 

And it works perfectly for what I need!

 

I forgot to mention -- to make it work for non-text Columns, convert the value to a string before evaluating:

 

{
  "$schema": "http://columnformatting.sharepointpnp.com/columnFormattingSchema.json",
  "elmType": "div",
  "txtContent": "@currentField",
     "style": {
      "background-color": {
         "operator": "?",
         "operands": [
            {
               "operator": "==",
               "operands": [
                    {
                        "operator": "toString()",
                            "operands": [
                                "@currentField"
                            ]
                        },
                        ""
                  ]
            },
            "#FF0000",
            ""
         ]
      }
   }
}

 

Thanks again, @Bibhu Panigrahi!

This is very close to what I want but would love to apply a bunch of formatting if a cell is not blank rather than just one particular style.  I'm struggling with the operator/operands syntax for applying a bunch of styles to the child element if the field is not blank.

 

This is the formatting that I would like but without formatting the blanks.

 

{
   "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
   "elmType": "div",
    "children": [
        {
           "elmType": "div",
           "txtContent": "@currentField",        
            "style": {
                "background-color": "#ffffe0",
                "text-wrap": "wrap",
                "font-size": "12px",
                "font-weight": "bold",
                "padding": "4px",
                "border-style": "solid",
                "border-width": "2px",
                "border-color": "#ffff00"
            }
        }
    ]
}

Is it possible to give more values a color, instead of just one?

Yes, you can!  Microsoft has posted a nice example of that here: 

 

https://support.office.com/en-us/article/Column-formatting-1f927342-2bed-4745-b727-ff8b7ff96b22

 

@Bibhu Panigrahiis also doing something like that further up in this post, here.

 

If i wanted to do the opposite, display a color only if there is a value in the column.
How would that look?

I haven't tried that, but I'm guessing you can take these lines:

 

            },
            "#FF0000",
            ""
         ]

 

and switch them around like so:

 

            },
            "",
            "#FF0000"
         ]

 

Nice!

Almost what I've been trying to do but would it also be possible to display an alternative text in the colored blank fields eg "Use default value"?

I'm trying to do this for a date field so I can't add "Use default value" as the default cell value for the column.

 

Thanks!

Can you help me if I would like to highlight cell 1A (in column A)  if cell 1B (in column B) is blank?

As I believe the code you gave is for the same column

 

@Jeremiah Benjamin 

Hi Jeremiah, this code of yours does exactly what I want except that for those list items containing an object (in my case users) it replaces the user name with the text string [object Object] any ideas on how to avoid that?

@Erik WettergrenI'm definitely no expert in this, sorry!  I just shared what worked (which I borrowed from @Bibhu Panigrahi and modified a bit by trial-and-error until I got what we needed). 

 

I've found a lot of good stuff here:  https://github.com/SharePoint/sp-dev-list-formatting/tree/master/column-samples

 

Those samples are great starting points, hopefully you find something useful.  Good luck!

@nanuarSorry I missed this!  I have referenced column data from 1 column and formatted a 2nd based on it in other SP Lists.  The downside is you have to display both columns in the View.

 

You can get some good examples of how it all works here:  https://github.com/SharePoint/sp-dev-docs/issues/1250

 

Best of luck!

Tanks, will look into those examples!

@Erik Wettergren, I use "txtContent": "@currentField.title" to get the user name instead of [object Object] in people columns. @Jeremiah Benjamin , thanks for tagging me to your response.