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