Conditional Formatting Files Older Than Certain number of days or years

[Michael Malloy]

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 modified date 2 years or more before today. 

The goal is to mark files that haven't been modified in the past 2 years (relative to today). Has anyone done this? If so can you please share the JSON? Please and Thank You!

[#2 · Accepted solution]

Hi Michael, (@Michael Malloy), 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

[#3]

@RobElliott 

Thanks! This is awesome!

[#4]

@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?

[#5]

@Michael Malloy  sorry for the delay in replying Michael. From the menu where your views are listed, select Format current view. In the example below I've got the All items view in standard list format, but in the view that I've named Tile I've formatted the items differently with JSON:

Rob
Los Gallardos

Microsoft Power Automate Community Super User

[#6]

@RobElliott 

Thanks so much for the video. I swear I only applied the json (Red files older than 2 years) to only 1 view. However, for some reason, that formatting seemed to bleed over into all views. I will do some more testing. Thanks again.

[#7]

@Michael Malloy if you apply the formatting to the column (from the column header) then it will be there in all views. If you apply formatting to the view then it won't.

Rob

Los Gallardos

Microsoft Power Automate Community Super User

[#8]

@RobElliott 

Ah I see! I will try that!

[#9]

@RobElliott  - could you show me this, but Bold if it meets the criteria, otherwise regular text.

Thx!