State Based Formatting with 2 Dependent Parameters?

I am using state based formatting i.e.

if      X<40               state = low

if      X<80               state = medium

if      X<100             state = high

Though I'd like to add an additional condition, such as...

if      Y = true          state = unavailable

Is it possible to do this with scripting?

The end goal:

I have a gauge that displays as red orange or green (depending on variable X), as shown below. However, if the "isConnected" variable (i.e. variable Y) switches to false, I would like the gauge to display a different colour, such as grey, for example.

Thanks!