Format Microsoft Project Gantt Bars by Resource
Question details
The user wants Gantt bars to use different colors or styles according to the resource assigned to each task.

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

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.

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.




