custom row colors in pivot table

[#1]

Hi Guys,

I want to change a color in particular entire  row  in pivot table.

[ashfaq_haseeb · Accepted solution]

Yes possible

Go to Setting --> user preference --> Design Tab --> Select Always show Design menu items.

Then right click on cell you want to highlight and select Custom format cell. --> apply your required formatting here.

Hope it helps.

Regards

ASHFAQ

[Anonymous]

Hi,

You can also write condition in background color option of your chart's dimension and expression.

Thanks

[#4]

thank you for your reply, could you please tell me what type of expression has to be use

[Anonymous]

For example,

If you have county wise sales and target and you want background color to be red for those countries who didn't meet target than you may use below condition in both dimension and expression background.

If(Sales<Target, Red())

[jyothish8807]

Go to Settings --> User Preferences --> Design and enable the option "Always Show Design menu Items"

Then right click on the totals row --> Custom Format Cell and change color, border, font etc.

Regards

KC