Coloring a cell as per the the value based on condition

[sn_9052]

Hi Experts,

Please find the attached excel file, where i need to get color as per the value present in cell.

Ex: If the cell value is DGR the cell color should reflect as "Green color" in Qliksense.

I did crosstable for all the months (1,2,3...12) and values(DGR,LGR..) as Data

like Crosstable(Month,Data,7)

So coloring the cell in qliksense i used the below expression. but its showing error.

If(Data="DGR",Green())  I even tried If(Data="DGR",RGB(102,204,0)) but no luck

Kindly help me with the Expression please

Thank You 🙂

[jwjackso · Accepted solution]

Use single-quotes,

If(Data='DGR',Green())

Use of quotes outside a load statement