In this example the color is correct…right?
I know you said everything is set correctly but I wonder if there is something being overlooked? It’s such a simple use case.
Without more details, the only other suggestion I can make is to NOT depend on ordering of the format rules. Instead, set the criteria to be distinct so that one and only one Format rule can be applied.
For example, set the criteria in Yellow to be:
AND([Airemedico_5_8_Bar] < -0.39, [Airemedico_5_8_Bar] >= -0.59)
And in Green, set it to:
AND([Airemedico_5_8_Bar] < -0.59, [Airemedico_5_8_Bar] >= -0.80)
The other two can be left as is.
NOTE: You are probably aware but thought I’d mention, no formatting is applied if the value is between -0.39 and 3.79 (inclusive)