Change Font colour

[fenil72]

Hi all,

I have 9 different climate types in my excel table, starting from arid to arctic. I would like the colours of the fonts to change as per the filter on the word.

For example, if I choose arid, I want the font colour to change to golden yellow.

Can somebody please help?

Regards,
Fenil

 

[cpg84]

Hi all,

I have 9 different climate types in my excel table, starting from arid to arctic. I would like the colours of the fonts to change as per the filter on the word.

For example, if I choose arid, I want the font colour to change to golden yellow.

Can somebody please help?

Regards,
Fenil

Use conditional formatting.

 

[fenil72]

It doesn't work because the pivot linked to my dashboard and I have a vlookup for the climate