Conditional Formatting Files Older Than Certain number of days or years

Hello Everyone, I'm aware of the new Conditional Formatting Rule builder that just dropped to my tenant last week. However, I'm wanting to implement formatting that will mark files that have a mo...

Document Library

files

Lists

SharePoint Online

sharepoint server

RobElliott
Apr 25, 2020
Hi Michael, (pnthrzrule), yes we do this at our company. The JSON is below and subtracts 2 years (in milliseconds) from today's date. If the Modified date is older than that then the date is red, otherwise it's green:

{ "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "color": "=if([$Modified] <= @now-63113904000, '#c64444', '#468757')" } }

Rob
Los Gallardos
Microsoft Power Automate Community Super User

RobElliott

Silver Contributor

Apr 25, 2020

Hi Michael, (pnthrzrule), yes we do this at our company. The JSON is below and subtracts 2 years (in milliseconds) from today's date. If the Modified date is older than that then the date is red, otherwise it's green:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "color": "=if([$Modified] <= @now-63113904000, '#c64444', '#468757')"
  }
}

Rob
Los Gallardos
Microsoft Power Automate Community Super User

pnthrzrule

Iron Contributor

Apr 28, 2020

RobElliott

Also...one more question...It appears that JSON applied to a library affects ALL views. Is there a way to restrict this to just the active view to which I'm adding the JSON?

Forum Discussion

Conditional Formatting Files Older Than Certain number of days or years

Resources