Switch Formula & Between two values

[DavidQMP]

Hi,



Is there a way to show any values between 0-0.2 as "Red", any between 0.2 and 0.4 as Orange etc? I'm not sure whether there is a different operator I'm missing..

Colour: Switch([Overall Rating]>0,"Red",[Overall Rating]>0.2,"Orange",[Overall Rating]>0.4,"Yellow",[Overall Rating]>0.6,"Green",[Overall Rating]>0.8,"Gold")

Thanks

[ranman256]

set the conditional formatting

[pbaldy]

You don't need a different operator, you need a different order. Switch returns the value for the first test that is met. With your test, everything meets the first one. Test in the opposite direction: <.2, <.4, etc.

[DavidQMP]

You don't need a different operator, you need a different order. Switch returns the value for the first test that is met. With your test, everything meets the first one. Test in the opposite direction: <.2, <.4, etc.

Ahhh thank you!!

[pbaldy]

Happy to help!