Microsoft List- How to format a row to show that it is "Due"

Question

Microsoft List- How to format a row to show that it is "Due"

Limon, Annabel 0

I need an item to turn red once the date column is 6 months out. This will show it is "Due" but won't change the date in the column. Just change the color.

0 comments

2 answers

Your answer

Answer 1

Jay1 Tran 600 Independent Advisor

Hi Annabel,

Thank you for reaching out.

You can use SharePoint column formatting to make the Due Date column display with a red background when the date is within six months. This formatting only changes the appearance of the column. It will not modify the stored date.

Please follow these steps:

Open the SharePoint list.
Select the Due Date column heading.
Select Column settings.
Select Format this column.

User's image

At the bottom of the formatting pane, select Advanced mode.

User's image

Remove any existing JSON and paste the following:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "style": {
    "background-color": "=if(@currentField == '', '', if(@currentField <= @now + 15811200000, '#d13438', ''))",
    "color": "=if(@currentField == '', '', if(@currentField <= @now + 15811200000, 'white', ''))",
    "font-weight": "=if(@currentField == '', '', if(@currentField <= @now + 15811200000, '600', 'normal'))",
    "padding": "4px 8px",
    "border-radius": "4px"
  },
  "txtContent": "@currentField.displayValue" }

Select Save.

The Due Date cell will now have a red background and white text when the date is due within approximately six months. Past-due dates will remain red as well. Blank date cells will not be formatted.

User's image I hope this information is helpful. Please try these steps and let me know how it goes. Should you have any further questions, please feel free to reach out and let me know. I'll be happy to help.

Thank you for your time and cooperation.

Limon, Annabel 0 Reputation points

2026-09-02T18:21:37.3866667+00:00

Hello,

Thanks for the quick reply! I gave it a shot and copy and pasted what you had but it changed everything red. I want it so that the date in the column (Example June 4) will only turn red if 6 months have passed. Right now it is showing it (June 4) red when it will be white.

Hopefully that makes sense. Anything will help. Thanks!

Jay1 Tran 600 Independent Advisor

Hi Annabel,

Thanks for clarifying.

To make the due date turn red only after it becomes six months old, please replace the existing formatting with the JSON below:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "style": {
    "display": "flex",
    "align-items": "center",
    "gap": "8px"
  },
  "children": [
    {
      "elmType": "span",
      "style": {
        "color": "=if(@currentField == '', '', if(@currentField <= addDays(@now, -183), '#d13438', ''))",
        "font-weight": "=if(@currentField == '', 'normal', if(@currentField <= addDays(@now, -183), '600', 'normal'))"
      },
      "txtContent": "@currentField.displayValue"
    },
    {
      "elmType": "span",
      "style": {
        "display": "=if(@currentField == '', 'none', if(@currentField <= addDays(@now, -183), 'inline-block', 'none'))",
        "background-color": "#d13438",
        "color": "white",
        "font-size": "12px",
        "font-weight": "600",
        "padding": "2px 7px",
        "border-radius": "10px"
      },
      "txtContent": "Due"
    }
  ]
}

This uses 183 days as an approximation of six months. Blank cells and dates less than six months old will remain unchanged.

Thank you for your time and patience. Looking forward to your response

Limon, Annabel 0 Reputation points

2026-09-02T19:08:00.0066667+00:00

Hello,

Thank you! Exactly what was needed.

Thanks again!
Jay1 Tran 600 Reputation points Independent Advisor

2026-09-02T19:20:37.1566667+00:00

Hi Annabel,

You’re very welcome. I’m glad to hear the formatting is now working as expected.

Please feel free to reach out if you need any additional assistance.

Best regards,

Answer 2

Use view formatting if the whole row should turn red, or column formatting if only the date cell should turn red.

For the entire row, in the list:

Select All items or Switch view options.
Select Format current view.
Select Advanced mode.
Paste this JSON and save:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json",
  "additionalRowClass": "=if([$DueDate] <= @now + 15768000000, 'sp-field-severity--severeWarning', '')"
}

This applies a red warning style when the item date is within 6 months from now or earlier. Replace DueDate with the internal name of the date column if the column has a different name. If the column name contains spaces, use the internal-name format such as Due_x0020_Date.

For only the date column, use Column settings > Format this column > Advanced mode and paste:

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

Notes:

@now is the current date/time when the list view loads.
SharePoint formatting supports date math by adding milliseconds to a date. Six months is approximated here as 15768000000 milliseconds.
This changes only the display color, not the stored date value.