Forum Discussion

April_Kingston's avatar
April_Kingston
Copper Contributor
May 30, 2024

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

Resources