Hello
Ive been geeting some great advice on the use of gantt chart in excel on this forum but now have slight glitch
I have the grant set up with conditional formatting auto completing the gantt chart based on the start and end date, including the sub categories.
My problem is: see attached file:
Line 2 to 6 work as the sub cateogies are longer than 1 week
Line 7 however is not populating the gantt as it is only 2 days long. However this task does need to be include in the gantt as if falls within this week (highlighted in red)
Any help is appriciated.
Thanks in advance
Bookmarks