Forum Discussion

Brady27's avatar
Brady27
Copper Contributor
Jun 25, 2022

Microsoft Lists Conditional Formatting Depending on number of days past

My goal is to have the last known date of an event change automatically green if it is 1-7 days past, orange if it is 8-14 days past, and red if it is 15-30 days past.   
JSON formatting
RobElliott's avatar
RobElliott
Silver Contributor
Jun 26, 2022

Brady27 

 

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "background-color": "=if(@currentField > @now -604800000, 'teal', if(@currentField <@now-604800000 && @currentField > @now-1209600000, 'orange', '#c00000'))",
    "color": "white"
  }
}

 

 

 

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Resources