Mar 23 2023 03:57 AM
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 all task that are completed (100%) to be green, those partially completed to be 2 colors (green and grey) and those not started (0%) to be blue. The green was easy but everything that are partially or not completed is blue. Can someone help me to fixed this?
Thank you,
Mégan
Mar 23 2023 05:57 AM
You can use conditional formatting to create a Gantt chart in Excel by following these steps:
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.
Mar 23 2023 06:20 AM
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
Mar 23 2023 06:31 AM
Mar 23 2023 11:36 PM