+ Reply to Thread
Results 1 to 2 of 2

Looking for Duplicates Highlight Whole Row

  1. #1
    Forum Contributor
    Join Date
    06-15-2013
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    214

    Looking for Duplicates Highlight Whole Row

    Hello Everybody,

    Let me explain exactly what I'm trying to figure out. I am looking in every row starting in Columns P, Q and R. It will go to the next row below the first and see if those columns have the same exact value. If it doesn't it goes onto the next row. If it turns out that row 1 matches row 2 then the program will then check to see if columns A-O in row 2 are all empty. If they are all empty then the entire row of Row 1 will be highlighted Red. If A-O are not empty it will skip over that row and go back to check columns P, Q, and R. This program would run until it gets to four empty rows in a row and then it will stop. I know it might sound confusing, The program is basically combining two worksheets and I'm seeing which files need to be deleted by marking it red. Thanks for your help.

  2. #2
    Forum Contributor
    Join Date
    06-15-2013
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    214

    Re: Looking for Duplicates Highlight Whole Row

    I also forgot to add that after it makes Row 1 red it would then need to delete Row 2 completely. And then restart the program and move onto the next row.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. highlight duplicates
    By dulitul19 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-05-2013, 06:34 AM
  2. Highlight Duplicates
    By bopsgtir in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-17-2012, 10:17 AM
  3. Highlight duplicates if col A and B are the same but not col C
    By Hond70 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2011, 05:01 AM
  4. Macro to check for duplicates and highlight duplicates
    By obc1126 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2008, 09:55 PM
  5. Highlight duplicates
    By SITCFanTN in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2006, 06:25 AM

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