Hi champs,


i have a pivot table copied as values ...

now i need to format the same with

1)all the values centered and bodered
2)row headings to be bold and colored (the row heading as the word "count" by defautl

i have attached the sample for the reference.
pls help me with a macro.sample.xlsx