colors in pivot table

[Carlaf_93]

Good afternoon,

is there a way to color the lines of a pivot table alternatively?

So, for example, the first line will be red, the second one blue and so on...

[sergio0592 · Accepted solution]

Hi,

You can use Even() function with as background color :

=If(Even(RowNo(TOTAL))=0, lightblue(), lightred())