I need an entire row to change color based on how soon a due date is approaching in a SharePoint list.
Due Date: 12/31/2021
When the due date is:
- 3 weeks away, I'd like the row to change to yellow.
- 2 weeks away, orange
- 1 week away, red
I'm not sure how to make this happen and am not familiar with using json.