Cactus1993
asked on
Excel: Conditional Highlighting
I have a list of numbers, many of which are duplicates.
Is there a way to highlight the duplicates, with different colors for the different sets of unique numbers?
Thanks in advance. Example attached.
Example-1.xlsx
Is there a way to highlight the duplicates, with different colors for the different sets of unique numbers?
Thanks in advance. Example attached.
Example-1.xlsx
Excel already has built-in Conditional Formatting rules to highlight cells with duplicate values. There is also a built-in Conditioning Formatting rule to highlight cells with unique values.
But since you are requesting unique colors for all inputs, take a look at this website with helpful tips and tricks on finding duplicate values in Excel: http://www.excel-easy.com/examples/find-duplicates.html
But since you are requesting unique colors for all inputs, take a look at this website with helpful tips and tricks on finding duplicate values in Excel: http://www.excel-easy.com/examples/find-duplicates.html
ASKER
I'm very familiar with the conditional formatting feature in Excel. What my question concerns is how to conditionally format duplicate values, with different colors highlighting matching sets of values, as per the spreadsheet example I attached. Thanks for the link, but it doesn't quite address my question.
If there are 500 matching sets, will you require 500 different colors?
ASKER
Lol. I'd only need 20-25 colors. But theoretically, if it works for 25, it should work for 500.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Ha sorry. I really need to read things more carefully.
Will you be working with one set at a time?
How about setting the CF to highlight all cells that are equal to the current active cell?
Thanks
Rob H
How about setting the CF to highlight all cells that are equal to the current active cell?
Thanks
Rob H
ASKER
Worked perfectly. Exactly what I needed.
Thanks!
Thanks!
ASKER