In the attached DB I want the backcolor of the control named "Difference" to change to red as soon as it's value changes from zero to some other value.
In the attached DB I want the backcolor of the control named "Difference" to change to red as soon as it's value changes from zero to some other value.
Have you looked at Condional Formatting on the ribbon?