Assign Color to Every Subject in Group

I would create a ranking within each group and join a list of colors to that but it is hard to give an example without seeing an example of the data. Could you post a small example of the data? Just a couple of groups would be enough.