Select the Home tab then choose Conditional Formatting. Start by selecting the range of cells where bars are to be displayed. An example is shown below on how cell colours can be changed sales figures green if they exceed a target figure of 1200.īy using conditional formatting we can easily create the following. We will be able to different colour task bars conveniently managed by conditional formatting. The task bars typically have start and finish dates and therefore have different lengths on duration.īy using Excel’s Conditional Formatting feature we can create our project task bars for our Gantt chart.

Recap: A Gantt chart is made up of task bars, one for each of the tasks required to complete the project in hand. You can also learn conditional formatting by attending Microsoft Excel training course. Step in Excel and the ever flexible conditional formatting function! Yes by deploying some neat conditional formatting tricks you can produce a presentable usable Gantt chart in Excel.

But what if you needed to update any of the tasks? This would usually mean lot’s of time consuming manual editing of cells.

Building a Gantt chart in Excel is pretty easy.

Easy gantt chart maker excel