How to put background color in a pivot table using expression ?

[Anonymous]

I want to highlight the cells in expression columns (Design, Vendor runoff & Launch) with yellow if the value of document is 'P', in a pivot table using visual cues.

Please assist.

[sunny_talwar]

So, if any of the three expression have P, you would want to highlight the complete row? or are you looking to just highlight the cell with P in it?

[Anonymous]

just that cell....

[sunny_talwar]

Try this for background color expressions

For Design expression

If([Design] = 'P', LightRed())

For Vendor runoff expression

If([Vendor runoff] = 'P', LightRed())

For Launch expression

If([Launch] = 'P', LightRed())

[Anonymous]

I have tried these expressions.

My question is where in pivot table I should put these expressions ?

[sunny_talwar · Accepted solution]

It should be on the Expressions tab under Background Color or Text Color.. depending on what you want to color...

[Anonymous]

Thanks Sunny....