Others

How to Set Conditional Due-Date Colors in Microsoft Lists

Steve KSteve K Nov 3, 2026 868 views

Question details

The user needs to apply color-coding to review dates in Microsoft Lists or SharePoint based on specific timeframes, along with setting up filtering and automated reminders.

How to Set Conditional Due-Date Colors in Microsoft Lists
Product
Microsoft Lists
Device & OS
not provided
Scenario
Tracking project or task deadlines visually to quickly distinguish upcoming, imminent, or overdue items.
Observed behavior
Items require automated visual indicators (like red for overdue) and notifications as they approach or pass their assigned due dates.
Before you start

Ensure you have 'Edit' or 'Owner' permissions for the Microsoft List or SharePoint site to modify column settings and apply formatting rules.

Solution 1Recommended

Use Column Formatting for Date Colors

Apply built-in conditional formatting to color-code dates based on when they are due.

Microsoft Lists and SharePoint provide built-in conditional formatting tools that allow you to change the background or font color of a column based on its value compared to the current date.

1
Access column settings

Open your Microsoft List or SharePoint list, click the header of your Date column, select 'Column settings', and then click 'Format this column'.

2
Manage formatting rules

In the right-hand pane, choose 'Conditional formatting' and click on 'Manage rules'.

3
Add date conditions

Add rules comparing the date to today. For example, choose 'If Date is before [Today]', then select a red background color.

4
Save changes

Add additional rules for yellow (e.g., within 30 days) and purple (on or after due date), then click 'Save'.

Use Column Formatting for Date Colors
Advanced Formatting: For more complex logic, click 'Advanced mode' at the bottom of the formatting pane to input custom JSON formatting codes.
Free Microsoft Office alternative

Manage Tasks and Due Dates Efficiently with WPS Office

While Microsoft Lists requires a specific Microsoft 365 setup, WPS Office provides a free, lightweight, and highly compatible alternative. You can easily build powerful task trackers with conditional formatting in WPS Spreadsheets, offering familiar tools without the extra cost.

  1. 1. Open WPS Spreadsheets: Launch WPS Office and create a new Spreadsheet to build your task tracker.
  2. 2. Set Up Columns: Add headers for Task Name, Assignee, and Due Date.
  3. 3. Apply Conditional Formatting: Highlight the Due Date column, click 'Conditional Formatting' under the Home tab, and set highlight rules for upcoming or overdue dates.
Easily apply conditional formatting to track deadlines and due dates.Fully compatible with Microsoft Excel (.xlsx) formats.Free, lightweight, and consumes minimal system resources.Familiar user interface makes transitioning seamless.
microsoft office alternative - wps office

Frequently Asked Questions

Can I filter Microsoft Lists by custom date ranges?

Yes, you can use the filter pane to select specific dates, or create a calculated column that outputs specific text statuses (like 'Overdue') and filter your list based on that text.

Why aren't my list color formatting rules updating automatically based on today's date?

Standard conditional formatting based on '[Today]' evaluates when the page is loaded. Try refreshing your browser page to ensure the current date is applied to your formatting rules.

Do I need a premium license to use Power Automate for list reminders?

Basic reminders using standard Microsoft 365 connectors are included in most Microsoft 365 business plans. However, integrating premium connectors or external services may require a standalone Power Automate license.