Regarding Pivot Table

[#1]

Hai,

This is regarding Pivot table. I have 100 records in the pivot table. I want to display each row/ Record in different color. Could someone help me on this?

Customer	Sales
Customer A	100
Customer B	200
Customer C	300
Customer D	400
Customer E	500
Customer F	600
Customer G	700
Customer H	800

Thanks in Advance.

[michael_anthony]

Dimensions and Expressions have a Text Color function where you can control the color. Usually it's something like If(Var > 0,Red(),Green()) but can use the RGB(x,x,x) function to calculate colors.

In order to get different colors on each row, in the Text Color function use =Color(RowNo()). Color returns the color from the standard pallette based on an index. RowNo returns 1 - 100 for each row.