Change color depending on the field value

[oemar00]

How to change the color of the background and/or fonts of the fields in a form depending on the value on the field, such red background and green and bold fonts when negative value but light green and pink fonts when positive, and no color when zero.
I think this is not complicated, ,but I just do not know how to do it.

 

[MajP]

Search "Conditional Formatting"

 

[oemar00]

Thank you Pat,
I found out there is a "conditional formatting" button on the format tab in the ribbon, when I click that then it ask if this is new rule, and shows what condition to choose what the effect I want to the fields.
Thank you to all who tried to help.

 

[Gasman]

Don't loose sight of the fact that coloration becomes chaotic and once you have more than a few colors, people can't separate the shades. I don't recommend this for more than three very distinct colors. Access has much better ways of sorting and filtering. You might want to study those instead.

So what would you think of this? Plus it has audio.

 

[Gasman]

But pretty, yes.

 

[Gasman]

Pretty yes. You get mucho points for pretty

Not mine, I assure you. That likely also comes with MVFs and attachments as well.