How to Set Conditional Due-Date Colors in Microsoft Lists
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.

- 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.
Ensure you have 'Edit' or 'Owner' permissions for the Microsoft List or SharePoint site to modify column settings and apply formatting rules.
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.
Open your Microsoft List or SharePoint list, click the header of your Date column, select 'Column settings', and then click 'Format this column'.
In the right-hand pane, choose 'Conditional formatting' and click on 'Manage rules'.
Add rules comparing the date to today. For example, choose 'If Date is before [Today]', then select a red background color.
Add additional rules for yellow (e.g., within 30 days) and purple (on or after due date), then click 'Save'.

Create a Calculated Status Column for Easy Filtering
Add a new column that automatically labels tasks based on the due date for easier sorting.
Set Up Automated Reminders with Power Automate
Create automated email notifications when an item hits a specific due-date threshold.
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. Open WPS Spreadsheets: Launch WPS Office and create a new Spreadsheet to build your task tracker.
- 2. Set Up Columns: Add headers for Task Name, Assignee, and Due Date.
- 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.

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.




