In the Total_bt field of my form, I want to dynamically change the color of the amounts based on their value?
Suppose you want to display in green the amounts above 100 dollars.
- In this case you first select the field.
- You then go through the menu FORMAT / CONDITIONAL FORMATTING.
- In the dialog box that appears, using the input boxes and combo boxes, you build an expression indicating that the field value is greater than 100.
- And you use the formatting features to customize the look to be associated with this criterion.