I have a form that is generated by a query. The query is populated via
table.

I want all values in the report that are over 1.99% to show up as red.
Those values at 1.99% and lower should show up as green. IOW, percent
values from 0 to 1.99% are good values and show green. Anything at 2%
and over is bad, and should show up as red.

I've created conditinal formatting in several different ways, using
the options available under conditional formatting. It seems that no
matter what I select, greater than, equal to, etc, all the values
change to whatever the cond format is supposed to be.

Just seems the cond formating is not evaluating each value.

Should this be placed into the query somehow? Kind of confused on
this one. Thought it would be straight forward formatting.

chris