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.
Example:
Workorder Color
25456977 White
05597853 Blue
05597853 Blue
02543254 White
02131654 Green
02131654 Green
If you just want to be able to pick out the duplicates, create a pivot table. This will group them together and can show the unique values with a count of how many there are.
