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,
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