Conditional formatting with two factors

Hello, everyone,
Probably a simple question, but I can’t figure out if and how to do it?

I want to format a field, but in a dependency to another field. Is that possible? For example:
If field A has the value 1, field B should be red if >10, green if <10. If field A has the value 2 then field B should be green at >20 and green at <20.


Ticket NR | SLA | Reaction Time
0815 | 1 | 9 (GREEN colour)
8457 | 1 | 11 (RED colour)
8427 | 2 | 12 (GREEN colour)

Is that possible?

You can either highlight A or the whole row.

I already know this, but unfortunately it does not help me with my question. My problem is that I want to set the selected color in relation to another field. Is that possible?

Like I said - you have 2 options, neither of which you want.

Thanks for your help, but sorry, i don’t unterstand.
Is something like this possible?

You’d have to highlight the entire row.

Ok, if I take the whole line, then I can refer to several fields for choosing the color? That would be also perfect!

@jom It sounds like you’re looking for this feature request: - upvote by clicking :+1: on the first post

Hi @jom.
In the meanwhile you could incorporate in your SQL code the logic by using a third column, and show there as Text RED, GREEN. And do a conditional on the third column.