Hello, I hope this is not confusing. I have a spreadsheet that in column C has list of workorder numbers. Some of the workorder numbers are repeated in column C and i want to change the line color to a random color if there is a repeat number. I really want the colors to rotate between colors so that it is easier to pick them out. It can be a set number of color just as long as they rotate.