I can find all the duplicates in a column. Is there any way to make each duplicate numbers have a different color? I might have six H023558 eight H12581 two D012584 five H23698 etc...
I need to sort the rows by all the duplicates in groups and thought maybe if I could get them different colors then I could find a way to group the colors.
Thank you
Kim
Not clear... Do you want all the XXXX and YYYY and ZZZZ values to be red.... or the XXXX values to be red, the YYYYY values to be green, the ZZZZ values to be blue.... or what?
Hi there.
A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.
Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks