Conditional formatting - automatic change of another column

Occasional Visitor

Hi there,


I have created a Sharepoint list, which is mostly used to monitor insurance policies to make sure they're up to date. I want to conditionally format the following columns: 




Is there a way to format the 'insurance status' column to automatically change to 'expired' if today's date is after the date input in expiry date? I seem to only be able to do it if the date is today or any other fixed date.

1 Reply
best response confirmed by Juan Carlos González Martín (MVP)

@Jedd_Kulis don't forget this only changes the formatting, it doesn't change the underlying data.


  "$schema": "",
  "elmType": "div",
  "txtContent": "=if([$InsuranceExpiryDate]>@now, @currentField, 'Expired')",
  "style": {
    "background-color": "=if([$InsuranceExpiryDate] > @now, 'teal', '#c00000')",
    "color": "white"




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