Conditional formatting based on number values

[andrew.garrett]

Is there way to conditionally format a number field in LIST VIEW based on its value? For example: if less than 0, highlight red

[ian.p]

Yes, that is possible:

• Create a UI type of logic block where the conditional evaluates if the number field is <0.
  • In the true pathway use an Apply Styles action to apply a style. In your use case, the PastDueDateFieldStyle style formats fields with red text
  • In the false pathway use an Apply Styles action to clear styles
• In the application, add an event action of type Load Data on List Form that calls the logic block.

The result should be something akin to this:

However instead of using the style mentioned above for this example I used RedTextYellowBackgroundField because as a person who is red/green color blind, the PastDueDateFieldStyle suffers from a contrast issue and I can’t easily see the difference that style causes compared to just regular black on white text, shown below: