Conditional formatting colour scales on different cell

[vwone]

Hi, I have used colour scale to format the % complete cell but I need the format to be the same in column a so I can hide column b. Is there an easy way of doing this I want to keep the colour scale? Thanks [TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 212"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Status[/TD]
[TD]percent complete[/TD]
[/TR]
[TR]
[TD]Complete[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]Complete[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]Complete[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]Complete[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]Some to plan[/TD]
[TD="align: right"]90%[/TD]
[/TR]
[TR]
[TD]Complete[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]Complete[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]Some to plan[/TD]
[TD="align: right"]90%[/TD]
[/TR]
[TR]
[TD]Complete[/TD]
[TD="align: right"]95%[/TD]
[/TR]
[TR]
[TD]progressing[/TD]
[TD="align: right"]50%[/TD]
[/TR]
[TR]
[TD]Complete[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]Complete[/TD]
[TD="align: right"]100%[/TD]
[/TR]
[TR]
[TD]Not started[/TD]
[TD="align: right"]0%[/TD]
[/TR]
[TR]
[TD]Not started[/TD]
[TD="align: right"]0%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

---