kenchristensen11
Board Regular
- Joined
- Oct 12, 2016
- Messages
- 52
Hello,
I've been tasked to customize the "Simple Gantt Chart Template" based in Excel to an Annual Template as oppose to the weekly one that's already in the Simple Gantt Chart Template. I need to adjust the following:
1.) I want the progress bar formatting to change from purple to the corresponding colors under "TASK" (i.e. blue, red, green, purple).
2.) Since this is Annual Planning, the days in Row 5 have been replaced with the Mondays of each month. I tried adjusting the conditional formatting, but can seem to make it work. You'll notice that in row 8, the other 50% doesn't extend past mid-August. Seems like a quick formula fix, but I'm stuck. Any help will be much appreciated!
[/IMG]
*A screen-shot is the customized layout*
I've been tasked to customize the "Simple Gantt Chart Template" based in Excel to an Annual Template as oppose to the weekly one that's already in the Simple Gantt Chart Template. I need to adjust the following:
1.) I want the progress bar formatting to change from purple to the corresponding colors under "TASK" (i.e. blue, red, green, purple).
2.) Since this is Annual Planning, the days in Row 5 have been replaced with the Mondays of each month. I tried adjusting the conditional formatting, but can seem to make it work. You'll notice that in row 8, the other 50% doesn't extend past mid-August. Seems like a quick formula fix, but I'm stuck. Any help will be much appreciated!
*A screen-shot is the customized layout*