how to create conditional color of pivot background

[#1]

hi

i create a pivot table - see photo .

now i want to color the ACTUAL background  in one color and the PLAN background in another color

both (ACTUAL and PLAN) are value of the same field

how can do it  ?

thank you

[ashfaq_haseeb]

Instead of writing formula,

Try be selecting color directly.

Regards

ASHFAQ

[#3]

ok but where to put it ?background color of what ? dimension ?

[#4]

hi

i try it . doesn't work , very strange

[ashfaq_haseeb]

Can you share sample to look over?

[jagan]

Hi,

It should work check whether the casing is different or if possible attach some sample file.

Regards,

Jagan.

[#7]

hi

i want to attache the file here but u cannot fine how to do it

[jagan]

Hi,

You can attach the sample file by clicking on Use Advance Editor and then by using Attach link.

Regards,

Jagan.

[#9]

hi thank you - see attache

[ashfaq_haseeb]

Is working fine

Have a look at attached image.

Regards

ASHFAQ

[#11]

hi

good to know so why it is not work for me.can you send me back the example ?