Colors Cells

[#1]

Hi guys, I need to get some cels iluminated depending the row, I attached the app and an excel pic of how I need it to be.

any help would be great!!

[Miguel_Angel_Baeyens · Accepted solution]

Hi Javier,

Go to the chart properties, Expression tab and expand using the [+] symbol at the left of the expression "Cantidad Incidentes", select Background color and use this expression:

If(SecondaryDimensionality() <> 0, If(ColumnNo() <= Severity_llamadas, RGB(100, 200, 50)))

SecondaryDimensionality() will prevent to color the totals column.

Hope that helps.

Miguel

[Miguel_Angel_Baeyens]

Hi Javier,

Use this one in the expression Background Color instead the one you already have.

Regards.

Miguel

[#4]

oook, I get it now, it´s working great, thanks miguel.!!