Coloring cells based on random number values within a column.

Hello again. I'm back because you people are awesome.

I attached the file I need help with along with a picture below

What I need to do is assign a different color for every different random value, but say I don't know how many values I have in total... and also could be any number value. So Since I don't know how many different values I have in the column I would like excel to figure it out and assign a random color for each value found accordingly.

Say there's 20 #11 that would be green while 45 the #33 would be blue and on and on and on... and every time I ran the macro the colors would be different each time but coloring similar values the same color in an effort to make it easy to see. (I already have the code for sorting smallest to biggest)


Capture.PNG

colors.xlsm

Flawless. Absolutely amazing!

When applying to my actual macro all I had to do was change which column the color macro ran on!