Crosstab formula

[rhoneyfi]

I have a cross tab in Crystal 9.0 where "Company Represntative" is the row, "Date" (by month) is the column and the summarized field is "Monthly Sales"

There are 10 reps. What I would like is for each rep's name to be shaded in a different color..this way, the reps could easily find their specific info. Any way to do this????

 

[rhoneyfi]

Ah, I just solved my own question..since I only have ten reps, I just used the x-2 formula

ex: if [rep_name] = "Larry" then blue
else if [rep_name] = "Scott" then red, etc...