Others

Highlight Completed and In-Progress Tasks in Microsoft Project

Muhammad TalhaMuhammad Talha Nov 13, 2026 869 views

Question details

Show completed tasks in green and in-progress tasks in yellow in Microsoft Project.

Product
Microsoft Project
Device & OS
not provided
Scenario
Distinguish tasks that are 100% complete from tasks that are between 1% and 99% complete in the same task view.
Observed behavior
A single highlight filter applies one highlight style to matching tasks and cannot assign separate colors to multiple completion conditions.
Before you start

Open your project in a task sheet view such as Gantt Chart and display the % Complete column. Check whether the Marked field is already being used for another purpose before using it to identify completed tasks.

Solution 1Recommended

Combine a yellow highlight filter with green Marked task formatting

Use two separate formatting mechanisms to display in-progress and completed tasks in different colors in the same task table.

These instructions apply to Microsoft Project desktop; command names may vary by version. The formatting changes the task table appearance, not the Gantt bar colors.

The Marked field does not support a custom formula. Maintain it manually, or use a trusted macro that sets Marked to Yes when PercentComplete equals 100 and clears it for other tasks.

1
Create an in-progress task filter

Go to View > Data > Highlight > More Filters. Select a task filter and click New. Name it In-Progress Tasks, then add two conditions joined by And: % Complete is greater than 0, and % Complete is less than 100. Save the filter.

2
Set the highlight color to yellow

On the Format tab, open Text Styles. In Item to Change, select Highlighted Tasks and set Background Color to yellow. Confirm the change, then select In-Progress Tasks from View > Data > Highlight.

3
Mark completed tasks

Right-click a task column header, choose Insert Column, and select Marked. Set Marked to Yes for tasks whose % Complete value is 100. Leave it as No for tasks that are not complete.

4
Set marked task formatting to green

Open Format > Text Styles again. Select Marked Tasks under Item to Change, set Background Color to green, and confirm. Check that completed rows are green and in-progress rows are yellow.

5
Update marks when completion changes

After editing % Complete, review the Marked column. Set it to Yes when a task reaches 100%, and reset it to No if a completed task is reopened. This keeps the two formatting groups separate.

Highlighting is not multi-rule conditional formatting: The yellow filter highlights one group, while the green style applies to tasks marked Yes. Changing a task to 100% complete does not automatically update its Marked value unless you add automation.
Free Microsoft Office alternative

Track color-coded task progress in WPS Spreadsheet

For a simple task tracker rather than a Microsoft Project schedule, WPS Spreadsheet offers a free, lightweight alternative with familiar spreadsheet controls and Excel format compatibility. Move task names and completion values into an .xlsx worksheet, then use conditional formatting for status colors. WPS does not fix Microsoft Project highlighting or replace its scheduling features.

Use conditional formatting to distinguish completed and in-progress tasks in a spreadsheet.Open, edit, and save Microsoft Excel .xlsx and .xls files.Work with a familiar spreadsheet interface for easy migration of tabular task data.Maintain a lightweight task tracker without needing Microsoft Project for basic status reporting.
microsoft office alternative - wps office

Frequently Asked Questions

Can one Microsoft Project highlight filter show completed tasks in green and in-progress tasks in yellow?

No. A highlight filter uses the Highlighted Tasks style for all matching tasks. Use View > Data > Highlight for the in-progress group and Format > Text Styles > Marked Tasks for a separately marked completed group.

Why did a task not turn green after I changed it to 100% complete?

The Marked field does not automatically follow % Complete. Insert the Marked column and set that task to Yes. Also check Format > Text Styles > Marked Tasks to confirm that its background color is green.

How do I keep tasks at 0% complete from being highlighted yellow?

In View > Data > Highlight > More Filters, edit your in-progress filter to require % Complete greater than 0 and less than 100, joined by And. Tasks at 0% or 100% will not match that filter.

Will these settings change the colors of my Gantt bars?

No. Text Styles controls the task table appearance. To change timeline bars, use Format > Bar Styles in Gantt Chart view; that is separate from task-row highlighting.

Can I use WPS instead for a basic color-coded task list?

Yes, if you only need a spreadsheet tracker. In WPS Spreadsheet, enter task names and completion percentages, select the completion cells, and open Home > Conditional Formatting to add separate rules for 100% and values between 0% and 100%. This does not reproduce Microsoft Project dependencies or scheduling.