Pivot table background color based on cell value

[ramyasaiqv]

Hi All,

I’m not sure what’s wrong with my expression, please can someone help me?

Based on the cell value the back ground color should change as follows:

Here is the expression I have written:   

                if(MXT_Data='N/A',rgb(211,211,211),

if(MXT_Data >=1 and MXT_Data <2,LightRed(),

iF(MXT_Data >=2 and MXT_Data <3,rgb(255,165,0),

                if(MXT_Data>=3 AND MXT_Data<4,Yellow(),

                                if(MXT_Data>=4 and MXT_Data<=4.5,rgb(34,139,34), Blue()

                                )))))

The requirement:

If  MXT_Data =’N/A’  then –Grey

if(MXT_Data >=1 and <2 – Red

iF(MXT_Data >=2 and ❤️ –Orange

if(MXT_Data>=3  and <4- Yellow

if(MXT_Data>=4 and <=4.5 –Green  otherwise Blue

[rubenmarin · Accepted solution]

Hi Ramya, the value in the table is calculated, but the color expression only cheks the field, maybe setting the same expression in the color expression? PFA.

[ramyasaiqv]

That worked. Thank you so much Ruben.

Regards,

Ramya