OK, so I'm trying to create a scoring meter similar to the 1 attached; but, I want the right side (Green) to get smaller while the left side (Red) gets bigger.
Here are example parameters I'd like to use:
Goal spending amount $150 (Full scale)
Amount spent so far $50 (Red side, Left) Also pointerScoring Widget.xlsx
Remaining amount $100 (Green side, Right)
ALL VALUES MUST BE VARIABLE!

So as my spending goes up the pointer moves accordingly and the red gets bigger as the green gets smaller......does that make sense?