How to add custom color on each expression?

[jim_chan]

Hi guys,

i have created a pivot table. problem is :

i want to add custom background color on the expression, but i don;t know how.

- i have tried background color on in the expression tab - ends up it colored my data instead of the expression title(Cost A - Cost D).

- I have tried custom format cell as well, but i only want Cost A-D in blue and Cost E-G is Green. - ends up all in blue.

So. Pls help! how to custom it?

Rgds

Jim

[jim_chan]

Hello Sunny,

But My "Cost" is expression. So, can i still create a custom background color for each of the expression?

[sunny_talwar]

That makes your life a lot more easier. When you will click on the + sign next to your expression label, you will see Background color show up. For the expression A,B,C, &D add =Blue() and for E,F,G add =Green()

[sdmech81]

Hi,

store the rgb colors in variables like,light blue n green as per your wish.then use the these variables in your expression.

Next as mentioned by others in above post, if you want background coloring of dimension then you should write the condition in dimension tab n then background coloring.If for expression then in expression background coloring.

your expression,cab be like sunny or varsha, but would suggest try using pick and try to avoid if in expressions aswell.

attach file if still facing problem.

--sachin

[jim_chan]

nope. by applying the background, it did change the bg color to blue. but i wanted the Cost A(title/header) to have Blue background instead.

How can i do that Sunny?

Rgds,

Jim

[jim_chan]

ok ..... is this one! Thanks!!!!!