Pivot Table

[#1]

Hi All,

I need to format my pivot table so it looks like more like the above. I can't figure out how to do it. I've tried every trick in the bag. I currently have the bottom and need to alter so it can resemble like the one above.

Please provide assistance.

[sunny_talwar]

Like this may be?

[#3]

Hi MRKachhiaIMP

Just wanted to get the format of the pivot table corrected. It was as easy as moving the cursor 'til I saw the blue area. Thanks for checking Manish.

[MK_QSL]

Go to your Expression Tab

Click on + sign

Write below expression under Background Color

IF(Odd(RowNo()),Green(),Yellow())

Change Green() and Yellow() to your desired color.

[#5]

Thanks Sunny is there anyway I can have different colors for each row? It's difficult to differentiate between the colors.

[sunny_talwar]

You can use something like this:

=Pick(RowNo(), LightBlue(), LightRed(), LightCyan(), LightGray(), LightGreen(), LightMagenta())

Change the colors to whatever you would like them (may be use RGB)

[#7]

Thanks for all your help community!!!!!