GANTT chart highlight complete

[nparsons75]

I have a gantt chart created in excel using cells as opposed to a graph.

task	start	end	%
			100

<tbody>
</tbody>

The gantt chart works to the right of this table example above.

Currently the conditional formatting will highlight cells in blue according to the dates. If I change the % to 100 (meaning complete) I need the bars currently blue to change to green.

Is this possible.

 

[dermie_72]

yes, add a condition that says if the % value is 100 the format is green, and select the stop if condition is true toggle.
That should work.