Form Field/Function problem

[messingerjc]

On my main form, I have 4 boxes/fields as numbers. I have a function that
takes the score from 3 of those fields and automatically adds them together
and returns the total score to that 4th box/field. That part works the way it
should. The problem I'm having and can't get to work is that if all 3 of the
separate score boxes have a score of 60 or higher then the total score should
be colored green, but if any of the 3 separate scores are below 60 then the
total score should be red. I've entered some code that would check the scores
of the 3 individual scores and change the color of the 4th box/field
appropriately, under the 'On Change' and/or 'After Update'. But I can't get
it to work. I'm not sure if I have the wrong coding, or if it's Access not
seeing the field change because it's automatically coming from a function or
what.

Any help would be greatly appreciated!

 

[RonaldoOneNil]

Simply select your total box and then use Format - Conditional Formatting

 

[messingerjc]

Sorry it took a while to respond, I've been extremely busy at work. I could
have sworn I had tried that before and couldn't get it to work, but I tried
it again like you suggested and it worked. Thank you for your help!