Pivot table border color

[pennetzdorfer]

Hello,

I noticed a strange behavior when using Custom Format Cell for a pivot table.

Apparently it's not possible to change the border color of expressions ... settings only apply to dimensions.

Please find the attached qvw. Does anybody have an idea?

[sujeetsingh]

Try this

, User Preferences>> Design>>Set Default Styling Mode Advanced.

[pennetzdorfer]

Default Styling Mode is already activated ...

[pennetzdorfer]

Any ideas ...?

[amit_saini]

Florian,

This may help you:

Re: Change color of pivot table expression line

Re: custom row colors in pivot table

Thanks,
AS

[#6]

actually in pivot table Total row consider a different row you need to format total separately,and on partial total too,if you make changes on one of partial sum total it will change all partial sum total for that dimension....

[#7]

try to switch to another chart style by right click pivot table--properties--style--current style, then try again to change bg color via customer format cell,  at least for me it works, I met the same weird situation before.

[krishna20]

Hi ,

Like this attached app ??

[krishna20]

Try this,

Disable Design grid and Enable. You will get custom cell format could be activated.