Gantt chart-- Conditional formula needed!

[vignesh_thegame]

HI Friends,
i'm preparing a gantt chart for tracking the production days and percent of completion and days remaining. i have used conditional formatting to update by production date by black bar and days complete by blue bar.
i also like to add the production complete to reflect in the column with color. Pls any one help me to prepare this report...

http://www.filedropper.com/gantt-chart-template-vignesh

 

[Andrew Poulsom]

I've already seen that image. It's only showing the blue and red formats, which you already have in your workbook in the link in Post #3.