+ Reply to Thread
Results 1 to 3 of 3

Highlight duplicate numbers with different colors in two columns

  1. #1
    Registered User
    Join Date
    06-28-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    1

    Highlight duplicate numbers with different colors in two columns

    Hi, maybe that is incredibly easy, but I really don't know how to do it: I have two columns (D and F) with a quite big amount of numbers (almost 5000) and I would like each different duplicate to be highlighted in a different color, it's not important what kind of color though.
    I already tried with Conditional Formatting, but it only uses one kind of color, so it's not right for what I'm asking.
    As an example:
    Please Login or Register  to view this content.
    Again, the type of color is not really important, I just need them to be different for easily recognize the duplicates.

    Thank you in advance.
    Last edited by 17_types; 06-28-2013 at 04:32 AM.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Highlight duplicate numbers with different colors in two columns

    Quote Originally Posted by 17_types View Post
    Hi, maybe that is incredibly easy, but I really don't know how to do it:

    Thank you in advance.
    Hi. this is incredibly difficult, for doing using conditional formatting. You'll need 1 rule for eatch number!

    Perhaps if you separate your numbers in categories...Or else, perhaps a VBA expert could be able to helps you.

    Good luck.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,634

    Re: Highlight duplicate numbers with different colors in two columns

    Please Login or Register  to view this content.
    after 56 colors it resets back to black and recycles colors....there are only 56 in the range
    if cell is blank against blank it will highlight because they are counted as the same

    here is link for step by step how to add macro should you need
    http://www.contextures.com/xlvba01.html
    Last edited by humdingaling; 06-28-2013 at 04:09 AM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1