On Tue, 11 May 2010 13:01:44 -0700, Repent34 wrote:
>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
What value are you using for the conditional formatting? Remember, 1.99% is
just a way of depicting the number 0.0199 - THAT value is what you'll need to
compare, assuming that it's a numeric field rather than a Text.
If it *is* a Text field (calculated using the Format() function for instance)
apply the conditional formatting condition to the numeric field instead of the
text field.
--
John W. Vinson [MVP]
|
Similar Threads
