Highlighting Non-duplicate rows across two tables of data

**Barking_Mad** · 12-03-2012, 08:13 AM

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.

**Fotis1991** · 12-03-2012, 08:23 AM

In Conditional formmating rules in range F1:F20,PUT THIS FORMULA.

=COUNTIF($A$1:$D$10,$F1)=0

**Barking_Mad** · 12-03-2012, 08:37 AM

Sorry, see amendment, it should have been F1:I20 not F1:F20

**Fotis1991** · 12-03-2012, 08:45 AM

So for eatch column a separate Cf.

As you did for F you do for G and so on..

=COUNTIF($A$1:$D$10,$g1)=0

**Barking_Mad** · 12-03-2012, 10:58 AM

Hi,

Im not sure this is working, or maybe it's me. Please see the attached where the highligted cells are the ones that should show up as such because data in the end column in the he 2nd table is different from the data in the end column of the 1st table.

Note when a new record appears on the list the position of students between the rows in table A and table 4 are no longer adjacent (7 BREEN, Tony). Im guessing an array would be used to compare information, but I dont know how