Change Excel Line Color [Closed]

Report
-
 RayH -
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


Thank you for your help

1 reply

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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!