Format a row in a valuelist

[#1]

Hi,

I'm using a Valuelist() function as dimension in a straight table and Pick() for the expressions. However I'm looking to change the background/text color for certain items in the pick list. Here is the dimension/expression example:

Dim:

=ValueList('Revenue','Expenses','Gross Profit')

Exp:

=Pick(Match(ValueList('Revenue','Expenses','Gross Profit'),

'Revenue','Expenses','Gross Profit'),

sum(Revenue),

sum(Expenses),

Sum(Gross Profit))

So is it possible to format (change the background/text color) of the Gross Profit row only or any other row individually within the same expression?

Thanks.

[Qrishna · Accepted solution]

yes you can.

See attached.

[#3]

Hi Check Multi Colored check box here

Also you can use Background color/Text color if it is straight table.

[Qrishna]

you wont be having colors tab for st and pivot tables instead we have visual cues.

we have to input expressions .

[#5]

yes, 1st is for other charts except Straight TB and Pivot Tb

[#6]

Thanks a lot, it works