My problem is that I want to color cells based on value. The color is irrevelant and I want it to be random. For instance I have 1000+ unique values, and I want items with each value to have same color. I know they'll be duplicating colors, I just want unique color, and it doesn't matter what it is. I don't think you can do this with conditional formatting unless you do it manually for all 1000+ entries.

Example:


Order# QTY
1 25
1 32
1 33
2 21
2 12
3 15
3 18
3 19

So I want all the #1 to have same color, all the 2 to have same color, all the 3, and so on.

Any tips? Thx!