Highlight only if conditional duplicates exsist

  • Thanks for looking guys

    I have a sheet with 10 columns and 1500 rows. what i am looking to do is a conditional format that only flags if 2 sets of duplicates exsist.

    For example A1 has 1 And B1 has 11
    Then A2 has 1 and B2 has 22. I dont want A1 And A2 to flag as a duplicate because B1 and B2 are different. Basiclly only flag if those two cells in a row match numbers throughout the sheet.

    Thanks in advance for your help

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: Highlight only if conditional duplicates exsist


    Thanks Rob, but there is one tiny problem. How do i make it ignore blank cells? Here is the exact way i have it entered.


    =(SUMPRODUCT(($F$7:$F$1500=$F7)*($H$7:$H$1500=$H7))>1

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

  • Re: Highlight only if conditional duplicates exsist


    Thats the ticket! It works like a charm. Thanks for your help Rob.

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!