Change Excel Line Color [Closed]

Question

Change Excel Line Color [Closed]

Report

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.

Example:

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

Thank you for your help

Change Excel Line Color
How to change notepad++ background color - How-To - Text editor
How to change excel date format to dd/mm/yyyy - How-To - Excel
How to change excel author name - How-To - Excel
How to change input text color in html - How-To - HTML
Excel vba color cell if value ✓ - Forum - Programming

1 reply

Ask a question

RayH · Answer 1 · 2010-09-14T16:06:35-0400

Answer 1 / 1

RayH
Sep 14, 2010 at 04:06 PM

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.

Change Excel Line Color [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!