Sharepoint List Conditional formatting for Due Date column

Question

I want to conditionally format a Due date column in sharepoint lists.

The idea is for it to Turn red letters once the original date entered is past. I tried the conditional formatting but didint work or doing it wrong But the date entered is a future date when the item is due. If that day is pasted then it should be red.

Answer 1

Hi @Ben,

You can use below JSON code to format your due date column.

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "background-color": "=if(@currentField < @now, 'red', 'white')"
  }
}

Or apply conditional formatting rule like below.

Make sure the "duedate" column is a date and time column type.

---

If the answer is helpful, please click "Accept as Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.