Conditional Style on percent column [SOLVED]

[calson33]

I tried applying a numeric range conditional style on a column that is formatted for percentages. However, nothing works - It always defaults to whatever style is applied to values less than the lowest comparison.

My styles are supposed to be applied like this:
[field] >= 100 - Green
[field]< 90  - Red
Everything else normal.

In that case, everything is red.
If I take out the <90, then everything is normal text.

It is never green, no matter how high the percentage numbers are.

Any idea on how to make this work?

Thanks!

EDIT- Ok, even weirder, I have similar conditional formatting on a percent column in a list on the very same report which works just fine. I suspect I am missing some very obvious.

[calson33]

User error..   :-[

The values are 1.00 = 100%, but I was looking for values between 90 and 100, instead of .9 to 1.0

[Lynn]

Oh I've done that too!!

[MFGF]

Yep - I've been there also. :)