Conditional Formatting to Create Simple Gantt Chart for Project Plans

Posted: July 30, 2013 by MaxFraudy in Excel
Tags: , , ,

There are numerous Project Management tools available in the market which make life easier while managing huge projects. But for simpler projects, you don’t need all that jazz, just a simple project plan template is all that is required. Well, you can use conditional formatting to create simple Gantt Charts. Here’s how:

Step 1: Create your list of tasks and the decide the proposed dates against them. On the top row, put down the dates (one in each column) like this:

Task List

Task List

Step 2: Go to Home tab -> Styles group -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format. In the dialog box that appears, put down this formula: AND(E$1>=$C2,E$1<=$D2) and click Apply after selecting the range that it applies to.

Conditional Formatting Rule

Conditional Formatting Rule

Now your plan should be all good and look like this:

Gantt Chart

Gantt Chart

You can also download a sample Gannt Chart file, with weekends greyed out as well.

Advertisements
Comments
  1. PeterEddington says:

    The sample file definitions are incorrect and do not have the same formula as the explanation above – it has absolute references $E$1… etc. instead of E$1

  2. […] Conditional Formatting to Create Simple Gantt Chart … – Jul 30, 2013  · There are numerous Project Management tools available in the market which make life easier while managing huge projects. But for simpler projects, you don … […]

Share your thoughts/feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s