I want to change a color in particular entire row in pivot table.
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.
You can also write condition in background color option of your chart's dimension and expression.
thank you for your reply, could you please tell me what type of expression has to be use
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.
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.
Retrieving data ...