Forum Discussion
Solved
Having trouble while conditional formatting
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,
the number option is as indicated, but you must define the ranges in the form of a decimal,
3 = 0.03
you would have to use the condition
x >=0 < 0,03
and
x >= 0,03 <= 1
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.
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?
you would have to use the condition
x >=0 < 0,03
and
x >= 0,03 <= 1
