How to Change Planned and Actual Colors in an Excel Gantt Chart
Question details
The user wants to customize the colors and shading for planned and actual progress values in an Excel Gantt project 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.
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.
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.
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.
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.
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.

Update Overall Theme Colors for the Gantt Planner
Use this method if you want to apply a completely new color scheme to the entire workbook, though it is not recommended for changing just a single specific rule.
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. Open your Template: Open your downloaded Gantt chart template in WPS Spreadsheet.
- 2. Access Conditional Formatting: Go to the Home tab, click on Conditional Formatting, and select Manage Rules.
- 3. Edit the Rule: Select the rule for your planned or actual bar and click Edit.
- 4. Apply Custom Colors: Under the Format options, choose the Pattern or Background tab to apply your new solid color and save the changes.

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.




