Results 1 to 9 of 9

Highlighting Non-duplicate rows across two tables of data

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Highlighting Non-duplicate rows across two tables of data

    Hi,

    I have two tables with data in them in A1:D20 and F1:I20
    These two tables will mostly contain the same information, but each month data from D1:D20 will change either in the form of one cell or maybe entire row(s) being added or deleted.

    Im looking therefore to compare each row in F1:I20 with all the rows in A1:D20 and if they either contain amended data or entirely new row(s) colour them red. I can do this comparing two columns, but when it comes to a range of cells Im struggling and my google skills dont seem ot be working.

    Any help appreciated.
    Last edited by Barking_Mad; 12-05-2012 at 08:23 AM. Reason: That should have read F10:I20 not F1:F20!

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