How do I add conditional colours to the dimension values in pivot chart?

[nikita42]

I have a table comparing current location to target location. I want to colour the cells where the current <> target in red. How do I do this?

Function	Current Location	Target
A	London	London
B	Bangalore	Mumbai
C	Glasgow	London
D	Bangalore	Bangalore

In this table, I would want to colour rows B and C in red.

[sunny_talwar]

Please find attached

[Peter_Cammaert]

Yes, it does work allright.

In your sample document, add this expression to all Background Color properties in each dimension (on tab Dimensions, expand the tree under each dimension name, select Background Color and click Edit...) and to the Background Color property of the expression (on tab Expression, expand the tree, select Background Color property and put the following in the Definition field).

=IF ([Location Category] <> Target, RGB(255, 204, 204))

It works without any other toggles, checks or properties that must be changed.

Good luck,

Peter

PS the color is not as bright as the one Sunny uses, because that type of red may hide the cell content. YMMV, you should experiment with different values to find a pleasing color.

[nikita42]

Got it! My cell background transparancy was set to 100%. That's why the colors didn't show up!

Thanks so much