Changing the Color of a Row in a SharePoint List (using JSON) based on a columns value

Question

So I have a SharePoint list with a column called modified. I used the following code to change the rows colors based on when it was last modified which works fine:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
  "additionalRowClass": "=if([$Modified] < @now && [$Modified] >= @now - 86400000, 'sp-field-severity--blocked', if([$Modified] < @now && [$Modified] >= @now - 259200000, 'sp-field-severity--warning' , ''))"
}

However, now I want it to be a dark grayish color instead of red. I have tried many different things, but cannot get it too work for some reason.

Ganesh Sanap - MVP · Accepted Answer · 2021-02-16 14:00:30Z

Try something like below:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
  "additionalRowClass": "=if([$Modified] < @now && [$Modified] >= @now - 86400000, 'ms-bgColor-gray120', if([$Modified] < @now && [$Modified] >= @now - 259200000, 'sp-field-severity--warning' , ''))"
}

This will apply ms-bgColor-gray120 class for first condition ([$Modified] < @now && [$Modified] >= @now - 86400000).

Similarly, you can apply any of the predefined classes given in below links as per your requirements:

Stack Exchange Network

Changing the Color of a Row in a SharePoint List (using JSON) based on a columns value

1 Answer 1

Your Answer

Hot Network Questions

Changing the Color of a Row in a SharePoint List (using JSON) based on a columns value

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions