Pivot Style

[cinnamorolls]

hi, i need some help for pivot style. i am using excel 2007.my report layout is in tabular and there is no subtotal or grand totals. there is a lot of columns. i wish to make the pivot to alternate the rows colour by customers (first column). i tried to apply the design with banded rows but i have duplicate customers ie: there might be 2 rows with the same customers so i wish these 2 rows to be of the same colour.
may i know how should i do it? many thanks.

[lcartwright]

You could use conditional formatting based on customer names?

[cinnamorolls]

oh but how do you do it? i have a lot of different customer names. thanks.
i wan something like this. if same ID then it will show the same colour. alternate rows.

Untitled.png

You could use conditional formatting based on customer names?