Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
right click on cell> format cell > apply color.
Regards
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
Hi Pratyush,
I already tried it , it's not working
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.
Yes, the expression I gave you has to be written in the background color of the expression.
Nice, you got that done.
Regards
Pratyush
Ohhhh,previousely, I didnt get it 🙂
Thanks.