Change of cells with a condition in table box

[praneshsapmm]

Can someone let me know how to change the color of cells with a given condition. attached are the details.

[MindaugasBacius]

In your case you can use this option in expression:

In definition field simply write nested If statement like:

If(Sum(F1) > 100, green(), If(Sum(F1) > 50, red(), black()))

Instead of color functions you can use RGB() but you need to know the values of your coloring.

There is also other option with Visual Cues: