Conditional Formatting in Microsoft Project Gantt Charts
Part two of a three-part series of blogs

Formatting Gantt Charts in Microsoft Project is a time-consuming process. This blog series explains how to create task bars that format themselves as you change information in the table.

  1. Step 1 - creating a custom field in Microsoft Project
  2. Step 2 - creating a custom format in Microsoft Project (this blog)
  3. Step 3 - creating a calculated custom field in Microsoft Project

Posted by Andrew Gould on 01 June 2011

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Project conditional formatting - creating a custom format

In the previous entry in this series we saw how to create a custom field and insert it into the task table.  Now we're going to see how to link this field to a custom format in the Gantt Chart.

Creating a Custom Format

To start creating a custom format, make sure you're in the Gantt Chart view and then from the menu, select: Format -> Bar Styles…

Setting up a custom bar format
  1. Scroll to the bottom of the list of formats and type in a new name.
  2. Use the drop list to select the name of the field you customised in the previous step.
  3. Choose how you want the bar to be formatted using these options.
  4. Click OK

You should now have the ability to select the Yes option from the custom field and see the relevant task bar change colour automatically!

Selecting a format manually Automatically changing format
Selecting YES from the list… …automatically formats the task bar.

We're nearly there, just one step remains.  Unfortunately it's the most complicated step of all - getting the custom field to calculate automatically when Santa is assigned to a task!  Read the next part of this series to find out how to do this.

This blog has 0 threads Add post