Hello! I'm new to this forum, so hopefully posting in the correct place!

I'm looking for help with Conditional Formatting. The attached Gantt chart works great for me at the moment, but I would like it to do more, namely to show progress of tasks by changing the cell colour to green as the % complete increases.

Milestone 1 takes place between 07 June and 20 Dec and is shown in red
As each underlying task is completed, the % complete changes (based on manual input in tasks under column G)
I would like cells AE5:BA5 to automatically change to green, but the rest of the row to remain red, to show that 80% of the task is complete based on the values in column G (and so on throughout the document).

Hope that makes sense! Any help much appreciated!