Colours in pivot table for one column

[#1]

Hi,

How to give one colour for entire colour(back ground) in pivot table.

regards,

ba

[#2]

You can use the function ColumnNo () to set the background color as desired

Ex.:

In your expression / background color

IF(ColumnNo() = 3, RGB(230,230,230), RGB(255,255,255))

[Jason_Michaelides]

Expand the expression in the properties dialogue box and click on background.  Enter a Colour (e.g. LightRed()) in the definition window, or RGB(x,y,z) or any other expression that resolves to some kind of colour setting (see F1 help for the possible colour functions)

Hoep this helps,

Jason

[jagan]

Hi,

Expand the Background color expression and give the below expression

=RGB(255, 0, 0) for red

=RGB(0, 255, 0) for green

etc.

Hope this helps you,

Regards,

Jagan.