Conditional Formatting (Colors) on Running totals

Hi

I am trying to conditional format the color on a running total field. The running total field is calculated.

Here is how i need the color formatted

if the running total < 0 - Red

If running total is >0 but less than next weeks N-Demand value - Yellow

If running total is >0 and greater than next weeks N-demand value - Green

So in this case for Instrument XYZ

Assume that demand is all positive (shown as negative in the viz)

Running total for Week 15 through 17 - Green

Week 18- Yellow

Week 19 - Yellow

How do i get this? Also i need only the running total calculated field colored and not the N demand and N supply fields.  I was able to do a binary red or not by assigning a default white color to everything >=0 and red to everything<0, however this requirement is more nuanced.

Viz attached - appreciate inputs

Adi