Change background color of selected cell in a pivot table

[#1]

Hi,

How possible can I highlight the cell color to yellow when they are selected as per the following snapshot?

Heok

[#2 · Accepted solution]

Hi Heok

you can you background color for each dim field  in dimensions tab

like

if (yourfield = 'value', yellow())

best regards

chris

[#3]

Thanks Chris!