If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional formatting not quite working right
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 |
#2
|
|||
|
|||
Conditional formatting not quite working right
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] |
Thread Tools | |
Display Modes | |
|
|