Forum Discussion
April_Kingston
May 30, 2024Copper Contributor
Excel Gant Chart - end date cell highlit not working
Hello Experts!
I've downloaded from Excel a Gant timeline template.
I've deleted the info I didn't need to give me a base to work from thinking that wouldn't affect the functionality of the worksheet.
However now the 'Actual End' column G, highlights columns from 'Actual Start' Column F, all the way through to column BP instead of only filling in cells up to that 'Actual End' date
Please have a look at the uploaded doc which should show what I'm working with
There is obviously some hidden naming conventions or coding or conditional formatting that I've missed.
Can someone help me to fix this please
Thanks
April
Not sure what it shall be for all formatting, but in in Name Manager to change PeriodActual on
it gives
- April_KingstonCopper ContributorSergei - thank you very much!! Works a treat.
April_Kingston , you are welcome