Forum Discussion
Sharepoint List Conditional column formatting based on date range
Hi you clever people, I am trying to get a DUE DATE column in my list to show red when the BID STATUS is 'Go', and the DUE DATE is within 5 days from now. To test it, we coded it so that it would co...
ganeshsanap, need help as well. I am looking for JSON code that will highlight the entire row if an item has not been modified for a week.
royk2022 Use JSON like below in SharePoint JSON view formatting:
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
"additionalRowClass": "=if([$Modified] < addDays(@now,-7), 'sp-field-severity--severeWarning', '')"
}
Make sure you have shown/included Modified column in list view.
Output:
Please consider giving a Like if my post helped you in any way.