How to give background color to cell along with Values?(Not through Visual cues)

[Shubham_Deshmukh]

For ABC row,% C condition ( if +ve,red())

For XYZ row,% C condition (If - ve , red())

Means,I have different conditions for each row.

And I want to color the cell along with % C value,but I am getting one out of them only.

Pls help.

[PrashantSangle]

right click on cell> format cell > apply color.

Regards

[prat1507]

You can use something like this

pick(match(Dim,'ABC','XYZ'),

if(% C condition>0,rgb(),rgb()),

if(% C condition>0,rgb(),rgb()))

You can specify rgb codes as per your wish.

Regards

Pratyush

[Shubham_Deshmukh]

Hi Pratyush,

I already tried it , it's not working

[Shubham_Deshmukh · Accepted solution]

I Got the answer.

Write the normal condition in expression & write compare and color codes condition in background color tab.So, it will give you background color and value as well.

[prat1507]

Yes, the expression I gave you has to be written in the background color of the expression.

Nice, you got that done.

Regards
Pratyush

[Shubham_Deshmukh]

Ohhhh,previousely, I didnt get it 🙂

Thanks.