Why is conditional text formatting so complicated?

Hey,

I understand the confusion.
The key thing to remember is that you need a True / True condition for the color change to happen.

Example 1 (min greater than 0)

• min: 14

• max: 50

• value: 34

You’ll get:

• First rule: True / True

• Second rule: True / False
  → The green color will be applied.

Example 2 (max less than 0)

• min: -50

• max: -2

• value: -35

You’ll get:

• First rule: False / False

• Second rule: True / True
  → Again, since one of the rules is fully True, the color will be applied.

Keep in mind: it’s not about the value being in between min and max  these are two separate rules, and both parts of a rule need to be True for the color to be applied.

Hope it helps!