+ Reply to Thread
Results 1 to 3 of 3

Highlight top duplicate cell

  1. #1
    Registered User
    Join Date
    05-31-2010
    Location
    Belgrade
    MS-Off Ver
    Excel 2003
    Posts
    19

    Highlight top duplicate cell

    Hi,
    I need help finding duplicate cells. In xls file I have two table (Table 1, Table2), both table has same columns ID1 and ID2. In Table 2 I have unique records in both columns and I need to find duplicate values in Table1 and only to higlight the top unique cell in column ID1. In attached file I manually highlighted 3 cells but I need to higlight in whole column ID1 based on a unique cell in Table 2 column ID1. Thank you
    Attached Files Attached Files
    Last edited by blade82; 09-20-2010 at 08:39 AM.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Highlight top duplicate cell

    Hi

    Here's one way with conditional formatting.

    rylo
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-31-2010
    Location
    Belgrade
    MS-Off Ver
    Excel 2003
    Posts
    19

    Re: Highlight top duplicate cell

    Thank you. That`s it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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