Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Hi,
You can use Even() function with as background color :
=If(Even(RowNo(TOTAL))=0, lightblue(), lightred())
Hi,
You can use Even() function with as background color :
=If(Even(RowNo(TOTAL))=0, lightblue(), lightred())