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]

May be something like this for background color:

=If([Current Location] <> Target, Red(), Green())

[nikita42]

I tried that, but it doesn't work on a table.

[sunny_talwar]

Would you be able to provide a sample?

[richard]

Have you tried this on the expressions?

[pooja_sn]

=if(not match([Current Location],[Target]),Red(),Green())

[nikita42]

I've attached a sample table. I need to colour all rows where the location category <> Target.

Thanks!

[Peter_Cammaert · Accepted solution]

Yes, it does. We have no idea what table you are referring to, and it works on all of mine. See attachment.

Follow Sunny's suggestion if you want a solution that works for you as well.

Best,

Peter

[nikita42]

For some reason, this just isn't working on my actual table. Could there be some options in the presentation or style tabs that need to be checked/unchecked?

[nagarjuna_kotha]

Like this?

!