Process Complete

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "img", "attributes": { "src": { "operator": "?", "operands": [ { "operator": "==", "operands": ["@currentField", "Yes"] }, "https://classic.fcdos.gov.uk/sites/projprocmaprw/PublishingImages/greentick.png", { "operator": "?", "operands": [ { "operator": "==", "operands": ["@currentField", "No"] }, "https://classic.fcdos.gov.uk/sites/projprocmaprw/PublishingImages/incomplete.png", "https://classic.fcdos.gov.uk/sites/projprocmaprw/PublishingImages/OptionalNo.png" ] } ] }, "title": "@currentField" }, "style": { "display": "block", "width": "90px", "min-width": "90px", "max-width": "90px", "height": "29px", "min-height": "29px", "max-height": "29px", "image-rendering": "pixelated", "border": "none", "margin-top": "5px" } }

testing out icon use

1236 This code is now working perfectly with a graphic for each drop down list. Gill wants this dropped in favour of the text version.

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "img", "attributes": { "src": { "operator": "?", "operands": [ { "operator": "==", "operands": ["@currentField", "Mandatory"] }, "https://classic.fcdos.gov.uk/sites/projprocmaprw/PublishingImages/Mandatory.png", { "operator": "?", "operands": [ { "operator": "==", "operands": ["@currentField", "Optional Yes"] }, "https://classic.fcdos.gov.uk/sites/projprocmaprw/PublishingImages/Optionalyes.png", "https://classic.fcdos.gov.uk/sites/projprocmaprw/PublishingImages/OptionalNo.png" ] } ] }, "title": "@currentField" }, "style": { "display": "block", "width": "90px", "min-width": "90px", "max-width": "90px", "height": "29px", "min-height": "29px", "max-height": "29px", "image-rendering": "pixelated", "border": "none", "margin-top": "5px" } }https://classic.fcdos.gov.uk/sites/projprocmaprw/PublishingImages/OptionalNo.png

This is code for the 'required' column that specifies an actual font size

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "font-size": "14pt", "color": { "operator": "?", "operands": [ { "operator": "==", "operands": [ "@currentField", "Mandatory" ] }, "#0969b3", { "operator": "?", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "@currentField", "Optional Yes" ] }, { "operator": "==", "operands": [ "@currentField", "Optional No" ] } ] }, "#ed7333", "" ] } ] }, "font-weight": { "operator": "?", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "@currentField", "Mandatory" ] }, { "operator": "==", "operands": [ "@currentField", "Optional Yes" ] } ] }, "bold", "normal" ] }, "font-style": { "operator": "?", "operands": [ { "operator": "==", "operands": [ "@currentField", "Optional No" ] }, "italic", "normal" ] } } }

Required

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "color": { "operator": "?", "operands": [ { "operator": "==", "operands": [ "@currentField", "Mandatory" ] }, "#0969b3", { "operator": "?", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "@currentField", "Optional Yes" ] }, { "operator": "==", "operands": [ "@currentField", "Optional No" ] } ] }, "#ed7333", "" ] } ] }, "font-size": { "operator": "?", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "@currentField", "Mandatory" ] }, { "operator": "||", "operands": [ { "operator": "==", "operands": [ "@currentField", "Optional Yes" ] }, { "operator": "==", "operands": [ "@currentField", "Optional No" ] } ] } ] }, "14pt", "" ] }, "font-weight": { "operator": "?", "operands": [ { "operator": "||", "operands": [ { "operator": "==", "operands": [ "@currentField", "Mandatory" ] }, { "operator": "==", "operands": [ "@currentField", "Optional Yes" ] } ] }, "bold", "normal" ] }, "font-style": { "operator": "?", "operands": [ { "operator": "==", "operands": [ "@currentField", "Optional No" ] }, "italic", "normal" ] } } }

Making text in list black with JSON

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "color": "#000000", "font-weight": "normal" }, "txtContent": "@currentField" }

revised code for top list to make n/a grey/ complete green and open Red. Changes to the fonts size and changed from bold to regular

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "font-weight": "regular", "font-size": "10pt", "padding-left": "0px", "color": { "operator": "?", "operands": [ { "operator": "==", "operands": ["@currentField", "Complete"] }, "#25a037", { "operator": "?", "operands": [ { "operator": "==", "operands": ["@currentField", "Open"] }, "#ff0000", { "operator": "?", "operands": [ { "operator": "==", "operands": ["@currentField", "N/A"] }, "#5d5d5d", "#323130" ] } ] } ] } } }