Conditional Formating based on percent value

[tngirl]

I have looked through posts and can't find anything that address this situation. I want to shade the text box on the report based on 3 percent ranges. I have tried using the field value option, but it doesn't work. I would like the values of 80% - 100% to be green background, 60%-79.99% to be yellow and 0 - 59.99% to be red. When I set the field value to those values, all values were red. Would an expression work better for me? If so, can you help with the expression. Thanks so much.

[JoeM]

What formulas have you tried exactly, that are returning those bad results?
If we see your formulas, and order, we may be able to tell you how to tweak it to get it to work.

[tngirl]

I didn't use any formulas, I just set the "between" values in the field value option setting. I finally got the color to work properly by reformatting my data to remove the percent sign. I would like to have the percent value sign so that is why I thought perhaps an expression would work better for me than the between value in the field value option setting.

[JoeM]

Note. Be sure to enter your percentages as fractions in your Conditional Formatting, i.e.
for 80% to 100%, enter

Between .8 and 1