Having trouble while conditional formatting

[gkbrkkszgl]

Hi all,

I am trying to do conditional formatting on the background color. Settings are below but the result is meaningless. Does anyone show me what I am missing? Thanks a lot,

[Syndicate_Admin · Accepted solution]

the number option is as indicated, but you must define the ranges in the form of a decimal,

3 = 0.03

[gkbrkkszgl]

Hi,

Yeah, that works with the decimal point and "number" options. But it still doesn't work with the percentage option. I did what I was trying to do but I think there is a minor bug in the program. Thanks a lot

[Syndicate_Admin · Accepted solution]

the number option is as indicated, but you must define the ranges in the form of a decimal,

3 = 0.03

[gkbrkkszgl]

Hi,

Yeah, that works with the decimal point and "number" options. But it still doesn't work with the percentage option. I did what I was trying to do but I think there is a minor bug in the program. Thanks a lot

[PowerUserR]

Hi,

Have you tried using "Number" insted of percent in the if statements? You could try working with tthe decimals instead. Other that that, this error seems odd.

[gkbrkkszgl]

Hi,

Thanks for the reply. The number option also didn't work. I also tried to add decimal places while defining the conditional range and also tried measure without decimal (just for try) and the result is the same. I didn't understand as well?

[PowerUserR · Accepted solution]

you would have to use the condition
x >=0 < 0,03
and 
x >= 0,03 <= 1