Pivot Table Font Size

[#1]

I have three dimensions in pivot table and two expressions..

Now i have sliced the last positioned dimension over expression

Now i want to change the size and colour of the data inside That last dimension

For e.g

name        city       total Amount

abcd     shanghai     20

defg     newyork       40

hijk       newdelhi     60

Mnop      shanghai     80

Now I have sliced it like this

name     City     shanghai       newyork       newdelhi       

abcd                    20

defg                                        40

hijk                                                            60

Mnop                    80

Now i want to change the font size and colour of only shanghai newyork and newdelhi

Help me Please!!!

[Anonymous]

PFA

IS it your requirement??????????

[#3]

hi nitin,

How you changed the color?

are you using custom style?

[#4]

Yes something like that ... but i want to make it bold and increase the size of font also...

How did you do that ??

[Anonymous]

USING CUSTOME FORMAT CELL

[Anonymous]

PFA the updated one

[#7]

Thanks a lot last thing..... can i put newdelhi newyork and Shanghai in the centre of cell

[Anonymous · Accepted solution]

PFA the update

[#9]

how did you made those dimensions in the center of  cell  in custom format cell ?

[Anonymous]

In presentation tab