Formatting Issues

How to Change Planned and Actual Colors in an Excel Gantt Chart

Muhammad TalhaMuhammad Talha Nov 2, 2026 870 views

Question details

The user wants to customize the colors and shading for planned and actual progress values in an Excel Gantt project planner template.

How to Change Planned and Actual Colors in an Excel Gantt Planner Template
Product
Microsoft Excel
Device & OS
Windows
Scenario
Customizing the visual representation of a project timeline template by changing patterned cell fills to solid colors.
Observed behavior
Conditional formatting works properly in the desktop version of Excel to change these values, but complex fill patterns may not display or edit fully in Excel for the web.
Before you start

Ensure you are using the desktop version of Excel, as complex conditional formatting rules and custom fill patterns may not display or edit correctly in Excel for the web.

Solution 1Recommended

Change Gantt Chart Colors Using Conditional Formatting Rules

Modify the specific conditional formatting rules applied to the Gantt chart template to change individual planned or actual colors without affecting the rest of the spreadsheet.

Excel Gantt chart templates rely heavily on conditional formatting to automatically color cells based on project start dates, durations, and actual progress. To change a specific color from a pattern to a solid fill, you must edit the exact rule controlling those cells.

1
Open Conditional Formatting Manager

Navigate to the Home tab on the Excel ribbon. Click on Conditional Formatting in the Styles group, and select Manage Rules from the drop-down menu.

2
Select and Edit the Rule

In the Conditional Formatting Rules Manager dialog box, ensure 'Show formatting rules for' is set to 'This Worksheet'. Locate the rule responsible for the planned or actual values, select it, and click Edit Rule.

3
Adjust the Fill Color or Pattern

Click the Format button in the Edit Formatting Rule window. Navigate to the Fill tab to choose a new solid background color, or adjust the Pattern Style if you wish to remove an existing pattern. Click OK to apply the changes.

Change Gantt Chart Colors Using Conditional Formatting Rules
Excel for Web Limitation: Some custom patterns and advanced conditional formatting rules applied in the desktop version may not render fully or allow editing in Excel for the web.
Efficient Project Management

Customize Project Timelines Easily with WPS Office

WPS Spreadsheet provides a lightweight and highly compatible environment to open Excel Gantt planner templates, allowing you to easily manage conditional formatting rules and customize project colors.

  1. 1. Open your Template: Open your downloaded Gantt chart template in WPS Spreadsheet.
  2. 2. Access Conditional Formatting: Go to the Home tab, click on Conditional Formatting, and select Manage Rules.
  3. 3. Edit the Rule: Select the rule for your planned or actual bar and click Edit.
  4. 4. Apply Custom Colors: Under the Format options, choose the Pattern or Background tab to apply your new solid color and save the changes.
Fully compatible with Microsoft Excel (.xlsx) formats and templatesAdvanced conditional formatting manager for accurate project trackingLightweight, fast-loading, and completely free to use
microsoft office alternative - wps office

Frequently Asked Questions

Why do my Gantt chart colors look different in Excel for the web?

Excel for the web has limitations in rendering advanced conditional formatting and specific custom fill patterns. For the best experience, edit and view your Gantt charts using the desktop version of Excel or a robust alternative like WPS Spreadsheet.

How do I change a patterned fill to a solid color in my project tracker?

Go to Home > Conditional Formatting > Manage Rules. Edit the specific rule controlling the cell, click Format, navigate to the Fill tab, and choose a solid background color while clearing any existing pattern style.

Will changing the Page Layout theme affect my conditional formatting rules?

Theme changes under Page Layout > Colors will alter the underlying color palette of the entire workbook. However, if a conditional formatting rule specifies a custom or standard color outside the theme, it will override the theme settings for those specific cells.