Highlight row yellow when 30 days before Expiry Date and red when expired

Copper Contributor

I'm a newbie to everything SharePoint and need help highlighting all rows yellow in a SharePoint list item that is 30 days out from the Expiry Date and red when it expires.


I found this JSON code which does half of what I want to do but I'm not sure how to add the other condition to get the result I need.


Any help will be greatly appreciated.


"$schema": "",
"additionalRowClass": "=if([$ExpiryDate] <= @now, 'sp-field-severity--severeWarning', '')"


2 Replies
best response confirmed by Ikaika1070 (Copper Contributor)

@Ikaika1070  the example below will change the row background to red if the date column, Arrival, is less than now but will change it to orange if the arrival is within the next 30 days:

  "$schema": "",
  "additionalRowClass": "=if([$Arrival] < @now(), 'ms-bgColor-red', if([$Arrival] >= @now() && [$Arrival] <= addDays(@now(),30), 'ms-bgColor-yellow', ''))"




Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP UK (and classic 1967 Morris Traveller driver)

That worked perfectly! I understand the logic now! Thank you so much!!!