Straight Table formatting using Background Color Expression feature:"

[treyknight]

I am attempting to color format my straight table so that there is a background color applied when the values a given field change/are not identical.

So, for example, please view some values in the ENGAGEMENT_LEVEL field:

row 1 = Super

row 2 = Super

row 3 = Super

row 4 = Low

row 5 = Low

row 6 = Heavy

row 7 = Business

In this scenario, row 1, row 4, row 6, and row 7 would be highlighted with a background color to indicate a change in field value.

Is there a way to do this? and if there is, could someone please teach me?

[rubenmarin]

Hi, it might depend of the table configuration, but you can use something like: =If(Value<>Above(TOTAL Value),Yellow())

Sample attached