Changing chart colour to reflect colour of cell

I am trying to get a column chart to reflect the cell colour based on its current colour. This is determined by the data resulting in either red, amber or green. I have attached an example and the chart is on the scoring tab.

A quick search came up with this

http://www.k2e.com/tech-update/tips/...nal-formatting

is that something you can work with?

Many thanks I will give it a go.