Conditional Formatting

jt1990

I'm trying to format my dataset using the Table tool so that numbers below 0.25 are unformatted, numbers between 0.25 and 0.5 are coloured green, numbers between 0.5 and 0.75 are coloured orange and numbers above 0.75 are coloured red.

I've used the column rule below but all numbers above 0.25 keep coming out green.

IF [Variance_Chargeable]<0.25 THEN "color: black;"
ELSEIF 0.25<=[Variance_Chargeable]<0.5 THEN "color: green;"
ELSEIF 0.5<=[Variance_Chargeable]<0.75 THEN "color: orange;"
ELSE "color: red;"

ENDIF

Does anyone have a solution for this please?

Thanks

Output

Accepted answers

Jean-Balteryx

Hi @jt1990 ,

For the orange rule, try using "Formula" with "Variance_Charge >= 0.25 AND Variance_Charge < 0.5".

Cheers,

Jean-Baptiste

All comments

Jean-Balteryx

Hi @jt1990 ,

I think you should create a rule for each condition.

As an example, if you want green text for values below 0.25 then set the rule as follow :

- "Apply" : WHEN Variance_Charge < 0.25

- "Styles" : tick Text Color and pick green.

If you need more details tell me.

Cheers,

Jean-Baptiste

jt1990

Thanks for the solution. Unfortunately this didn't work as anything above 0.5 was coloured red and anything below 0.5 was coloured orange. The numbers below 0.25 weren't coloured green. I've pasted screenshots of the rules below - do you have any other suggestions please?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703