Conditional Formatting

[markedback]

I am trying to apply Conditional Formatting to a text box in a report by using the Conditional Formatting option on the pop menu.

The condition is that if the value (sum of 4 other values) in text box is less than or greater than or not equal to 1 than the fore color will change to red but if the value is equal to 1 then it maintains the default fore color green. The text box is formatted to show the value in percentage format.

This text box shows the sum of quarterly sales for 3 different salespersons. Conditional Formatting is working when the conditions are true but not when they are false i.e. if the value is equal to 1, the fore color becomes red instead of staying the default green. I don't know what could be causing this.

Please advice.

Thanks in advance!
-Mark.

 

[MajP]

If possible first change your formatting to keep it simple. Make the default red, and change it green if it equals 1.
One condition. Test this to see if it works. Because there may be a floating point arithmetic error. (you can google to read about it). Although you may see 1 in the textbox the value may actually be something like 1.00012. In that case set up your conditions with a tolerance something like.

>.999 and <1.001