How to use conditional formatting to create a Gantt chart in Excel?
The Gantt graph can describe the process of the program, but do you know how to use the Conditional Formatting feature to create a simple Gantt chart in Excel? In this article, I will introduce the steps on creating Gantt chart by conditional formatting.
Supposing your data list as below screenshot shown:
1. Select the cells which are in the date columns, D2:Z7, and click Home > Conditional Formatting > New Rule. See screenshot:
2. Then in the New Formatting Rule dialog, select Use a formula to determine which cells to format in the Select a Rule Type list, and type this formula =AND(D$1>=$B2, D$1<=$C2) into the Format values where this formula is true textbox, and click Format. Then in the Format Cells dialog, enable the Fill tab, and select one color you want to use for highlighting. See screenshot:
In the formula, D1 is the first cells which in the date columns, B2 is the first start date in Start Date column, and C2 is the first end date in the End Date column.
3. Click OK > OK, the Gantt chart has been displayed.