I am trying to create / modify my very first Gantt project plan, but am stuck in getting the conditional formatting when trying to fill in a color code for the progress of the project.

I have attached the chart I'm trying to build based on a base downloaded from the net.

What I want to do:

1. Be able to see the duration of the planned task on the chart (one color, blue f. ex.)
2. Be able to mark the completed tasks on green block at the chart. (Based on the percentage filled by the person working with the project, where 0% is task not started and 100% task completed)

This is a very basic question, but I hope you can help me to build the right rules for this as I am stuck and I really need to get this working for my projects...project model.xlsx