Change the Colour on a Gantt Chart line

[Kevin1957]

Hi, I have bought the attached Gantt Chart but I have been trying for ages to be able to change the colour of the bar from grey hatched to a solid Green when its 100% Done. If i can find out how this is done I can then hopefully put in different colours depending on the amount of % completion, eg. 50% Amber, 0% Red.

 

[vletm]

Kevin1957
Did You mean below 'grey hatched' ... or which?

 

[Kevin1957]

Yes but when I change it to green in the worksheet rules it shows green even when its not 100%

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Kevin1957]

Hi Narayan,

Thank you so much for this. Is it possible to tell me how you did it?

 

[GraH - Guido]

Hi Narayan,

Thank you so much for this. Is it possible to tell me how you did it?

I believe Vletm showed you directly in #2... In the conditional formatting rules, select the rule and edit it. Search for "format" then "fill". And confirm changes with OK 3 times.