Change Speedometer chart Gauge color based on range

[vivekneo]

Hello all,
Kindly help me with a small macro or vba script, to change the gauge color based on pointer range value.

Here is excel file : http://devserver.swsdreams.com/client/mrexcel/speedometer-final.xls

Please see the color range in Ranges column. Is there any way to change the Gauge/pointer color when the value is changed dynamically.

Any help will very thank ful.

 

[vivekneo]

If i was not very clear on top, the "needle" / "pointer" color needs to be changed dynamically.