Forum Discussion
Megan365
Mar 23, 2023Copper Contributor
conditional formatting for gantt chart
Hi, I use one of the gantt chart template provided on microsoft site to create my first gantt chart. It works really well but I have some trouble with the conditional formatting. I would like al...
NikolinoDE
Mar 23, 2023Gold Contributor
You can use conditional formatting to create a Gantt chart in Excel by following these steps:
- Select the cells that contain the start dates and end dates of your tasks.
- Go to Home > Conditional Formatting > New Rule.
- Choose “Use a formula to determine which cells to format”.
- Enter this formula: =AND($B2<=TODAY(),$C2>=TODAY())
- Click Format and choose a green fill color. Click OK.
- Repeat steps 2 to 5 with this formula: =$B2>TODAY() and choose a blue fill color.
- Repeat steps 2 to 5 with this formula: =$C2<TODAY() and choose a gray fill color.
This will create a Gantt chart that shows the progress of your tasks with different colors. You can adjust the formulas and colors according to your preferences.
I hope this helps.
Megan365
Mar 23, 2023Copper Contributor
Hi Nikolino,
Thank you verify much for your help. Just to make sure, do I have to delete any previous conditional formatting? And if I apply your recommendation will it change the cell progress or data bars to different color?
Thank you again,
Mégan