Coloring sql reporting services report depending on the change of value of a certain field

Question

Hey guys,

I have an SSRS report that looks something like this:

     Column1 Column2
Row1 2          A
Row2 2          B
Row3 2          C
Row4 6          A
Row5 11         E

how can I color the rows with the same value in Column1 with the same color? for example Row1 to Row3 would have one color, Row4 would have a different color, then I'd go back to Row1's color for Row5?

note: I don't know in advance the numbers returned in Column1. I query for them and then I hide them from the user so Column1 shouldn't show on the report, but I want to use it for the coloring only.

Answer 1

yes, I do want to get alternating colors, but I don't know how to since I don't know in advance the number of rows to color.