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

Status percent complete Complete 100% Complete 100% Complete 100% Complete 100% Some to plan 90% Complete 100% Complete 100% Some to plan 90% Complete 95% progressing 50% Complete 100% Complete 100% Not started 0% Not started 0% <colgroup><col><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

---