Change Excel Line Color

PACSBilly - Sep 14, 2010 at 07:56 AM
 RayH - Sep 14, 2010 at 04:06 PM
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.


Workorder Color
25456977 White
05597853 Blue
05597853 Blue
02543254 White
02131654 Green
02131654 Green

Thank you for your help

1 response

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.