Others

Format Microsoft Project Gantt Bars by Resource

Ayan MasoodAyan Masood Nov 20, 2026 868 views

Question details

The user wants Gantt bars to use different colors or styles according to the resource assigned to each task.

Format Microsoft Project Gantt Bars by Resource
Product
Microsoft Project
Device & OS
not provided
Scenario
A project schedule needs Gantt chart formatting that distinguishes tasks by their assigned resources.
Observed behavior
Gantt bars represent tasks rather than resources, so resource-based bar formatting is not available as a simple built-in setting.
Before you start

Open the project in Gantt Chart view and check the Resource Names column to see which resources are assigned to each task. The flag method works most clearly when each task has only one assigned resource.

Solution 1Recommended

Use task flags to color Gantt bars by resource

Use this method to apply resource-specific colors when each task has one assigned resource and you can maintain the flags manually.

Gantt bar styles can use task flags as conditions. Assign a different flag and bar color to each resource you want to distinguish.

1
Add a flag column

In View > Gantt Chart, right-click a column heading, select Insert Column, and choose Flag1. Add Flag2 and additional flag columns for other resources.

2
Mark tasks for each resource

Use the Resource Names column to identify tasks assigned to the first resource, then set their Flag1 values to Yes. Repeat with Flag2 and the corresponding resource, and continue for the remaining resources.

3
Create a bar style

On the Gantt Chart Format tab, open Bar Styles. Add a row for the first resource, enter a descriptive name, and set Show For Tasks to Normal,Flag1, From to Start, and To to Finish.

4
Choose colors and repeat

In the Bar Styles dialog, select the new row and use the Bars tab to choose a color. Add a separate style for each remaining flag, choose its color, and select OK.

5
Check the chart

Review the Gantt Chart to confirm the expected tasks have the matching colors. If a standard task style overrides a flag style, move the flag style below the standard Task row in Bar Styles.

Use task flags to color Gantt bars by resource
Flags do not update automatically: Change the flags when resource assignments change. For automatic resource-based updates, a VBA macro is needed. Tasks with multiple resources also need a rule for which resource's color takes priority.
Free Microsoft Office alternative

Create and share project tracking tables in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with project tracking spreadsheets and documents. Its Microsoft Office format compatibility helps you move existing files across. It does not automate Microsoft Project Gantt bar formatting.

Use spreadsheet tables and cell colors to organize project tasks and resources.Work with Microsoft Excel, Word, and PowerPoint formats, including XLSX, DOCX, and PPTX.Use a familiar interface to move everyday office work to WPS Office.Get a free, lightweight office suite for common document tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Can Microsoft Project automatically color Gantt bars by resource?

There is no simple built-in setting that directly applies Gantt bar colors by assigned resource. Task flags and Bar Styles provide a manual method; automatic updates require VBA.

What happens when a task's assigned resource changes?

The task's flag does not change automatically. Update its flag columns in Gantt Chart view so that the correct resource-specific Bar Styles condition applies.

Why is my flag-based bar color not showing?

Check that the task's flag is set to Yes and that the Bar Styles row uses the matching flag in Show For Tasks. Also move the flag style below the standard Task row if another style is overriding it.

Can I use this method for tasks with multiple resources?

You can set multiple flags, but competing bar styles may overlap. Decide which resource should determine the displayed color and set the flags and Bar Styles order accordingly.