Gauge Threshold Colors from Transform Data

I have a Gauge panel that I am setting Threshold and Max values from a transformation. I would like the color for below Threshold to be Red and above threshold to be green. Can’t seem to get the colors to do this. Attached is a pic of my config.