Conditional Formatting on a Field that is on many layout...is there a better way?

4

here is another technique: Dynamic background colour. This method can be implemented entirely within a single field, eliminating the need for conditional formatting.

  1. Create a calculated two-line text value
TextColor ( "status" ; RGB ( x ; x ; x ) )  &¶&
TextColor ( "██████" ; RGB ( x ; x ; x ) )

  1. Use a custom function to control the color dynamically based on your logic

  2. On the layout, set the line height of the field to a small value (e.g. 0.2) so that the two lines overlap, creating the appearance of a colored background behind the text.

1 Like