Visual guides in a Pivot Table

[#1]

Hello everyone,

i was wondering if there's a way to combine colors in the backgrond of a pivot table to use them as visual guides(like pyjama stripes in a straight table), i would like to get a pivot table to look like this.

if anyone can help i qould apriciate it

Best regards.

[pover · Accepted solution]

I wouldn't recommend using so many colors, but if you enable the Design Grid found in the View menu option, you can right-click on the table column and you will see an option called Custom Format in the right-click menu.  That will allow you to change the background color of that column.

Or, you can use an expression like if(rowNo()/2=floor(rowNo()/2),LightBlue(),Blue()) in the background color of the column in your pivot table to color alternate rows differently.

Karl

[#3]

Thanks, Karl - I never knew that how to change cells and headers like that. Very helpful!

[#4]

Thank you very much Karl that expression it's indeed what i was looking for, sorry about the late answer i was very busy, thats a lot your help it's apreciated

Best regards.

[anderseriksson]

> if(rowNo()/2=floor(rowNo()/2),LightBlue(),Blue())

What a complicated way of calculating Even!

Try if(Even(RowNo()), LightBlue(), Blue()) instead.