Forum Discussion

SoniaW365's avatar
SoniaW365
Copper Contributor
Dec 18, 2024

Conditional Formatting using JSON

I have this code which is working great, however, every time I make a change to add in that if it is blank it should be light coral as well -    here is the original -  { "$schema": "https://devel...
Document Library
microsoft lists
SharePoint Online
NicolasKheirallah's avatar
NicolasKheirallah
MVP
Dec 25, 2024

Fixed it for you :)

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "background-color": "=if(isBlank([$Emp_x0020_Returns_x0020_OF306]) || isBlank([$LP_x0020_Sends_x0020_OF306]), 'LightCoral', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) <= 10, 'LightGreen', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) >= 11 && (Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) <= 20, 'LightYellow', if((Number([$Emp_x0020_Returns_x0020_OF306]) - Number([$LP_x0020_Sends_x0020_OF306])) / (1000 * 60 * 60 * 24) > 20, 'LightCoral', '')))))",
    "color": "black",
    "padding": "5px",
    "border-radius": "5px"
  }
}

 

Resources