I am currently designing a form in MS Access.
The user selects a product and that product has a target output. That target is displayed for the user on the form.
The user enters the actual output and I am trying to get the conditional formatting to colour either red or green, depending on whether the actual is greater or less than the target.
For some reason, the formatting is active, but sometimes incorrect. Example -
Target - 2520 units per hour. Anything equal to or above is green, anything below is red.
Actual - 100 (showing red - correct)
Actual - 29 (showing green - incorrect)
Actual - 2400 (showing red - correct)
Actual - 500 (showing green - incorrect)
Any idea as to why the rules are not being adhered to consistently?