As a follow up to the above, when I unpivot the differentfield that I am interested in formatting on, the formatting works. Looks like it’s the pivoting that is the issue.

Hi @rufus thanks so much for the response! Unfortunately referencing {<!-- -->{ differentfield._value }} doesn’t seem to work for me. I should note I’m applying these if statements to a measure that is an average, and the differentfield._value is a dimension...

This is really helpful! Is there any way to pull additional looker fields from the same view into your if statement? Example: dimension: count { sql: ${TABLE}.count html: {% if value &lt;= 30 and different_field.value == “Good” %} [color red] {% elsif v...