Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone let me know how to change the color of cells with a given condition. attached are the details.
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: