Confused on Shading

[nervous2]

I'm making a simple report that list customers by 10 different sales agents I'm trying to set a background shade (some type of grey) for odd and even customers to vividly show that that particular section is for that sales person.

I have managed to set the shading for a particular agent but is there some way I can say ie:
(this is what I have now, so this mean that the sales agent BN then the background colour is grey
if {ARCUST.Salespersn_Ky}="BN" then color(205, 205, 205)

but I want the next agent on that list to have a darker shade background then the next one after that, back to 205,205,205

can I use
if {ARCUST.Salespersn_Ky}=odd then color(205, 205, 205)else if even then colour (225,225,225) somewhere along those lines? therefore if new agents come into my company I don't have to specify them directly in the report.

Thanks

 

[bdreed35]

If you are just using the one grouping, you can use the groupnumber field

change you color conditional formatting to this:

if groupnumber mod 2 = 0 then
color(195,195,195) //or whatever the darker shade should be
else
color(205, 205, 205)

~Brian