Shading every other row in Pivot table

[#1]

Hi all,

I'm trying to shade every other row in a pivot table simply based on being the odd or even row number. In other words rows 1,3,5,6,9,etc. would be a color and 2,4,6,8,10,etc. would be another color.

I've tried to write code on the background color of the field using rowno() and count() but no success.

Any suggestions would be extremely helpful.

[#2]

Sure ...

Go to an expression in a chart/table/... and open the definition window. In the file menu you can find the Color Mix Wizard.

See image

[#3]

Thanks Mark.

I've been searching the forum for examples using the ColorMix wizard. Do you know of any?

[#4]

Nope, just learned about it today ...

Going to test it tomorrow though. I will post something about it afterwards.