Let me start by saying that I have also posted this on MR Excels forum, and recieved no replies. so... here goes.

I am trying to conditionally format a Donut/Speedometer chart. ( I saw it on peltiertech.com) howver I need the actual Donut part to change colos, based on the value input for the needle. Green for A positive and Red for a negative. any ideas?

Tempus