{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”,
“elmType”: “div”,
“style”: {
“padding-left”: “20px”,
“font-weight”: “bold”,
“background-color”: “=if(Number(@currentField)==0, ‘#CE70F9’,if(@currentField <= @now + 2592000000, ‘red’,if(@currentField <= @now + 7776000000 && @currentField > @now + 2592000000,’orange’,if(@currentField <= @now + 15552000000 && @currentField > @now + 7776000000,’yellow’,’lightgreen’)))”
},
“txtContent”: “=if(Number(@currentField)==0, ‘No Information’,[$_x0052_AL3.displayValue]”
}
__________________________________________________
today 15/11/2022 – RED
plus 30 Days – 15/12/2022 -RED
plus 31 days – 16/12/2022 – ORANGE
PLUS 90 DAYS – 13/2/2023 – ORANGE
Plus 91 Days – 14/2/2023 – YELLOW
PLUS 180 DAYS – 14/5/2023 – Yellow
Plus 181 Days – 15/5/2023 – BLACK
plus 30 Days – 15/12/2022 -RED
plus 31 days – 16/12/2022 – ORANGE
PLUS 90 DAYS – 13/2/2023 – ORANGE
Plus 91 Days – 14/2/2023 – YELLOW
PLUS 180 DAYS – 14/5/2023 – Yellow
Plus 181 Days – 15/5/2023 – BLACK
