Highlighting data mismatches in tables by row

[angeloudaki]

I have tried

=$A1<>$B1

but this only looks at two cells at a time.

=$A1:A5<>$B1:B5

does not work.

Ideally I would like Excel to check for differences between two tables row by row and highlight them. If not then at least return True/False for a range. I have a lot of data to sift through! I have searched online and again no luck. I also tried 'GoTo special' but it picked up cells which matched too. It seemed a completely random result.

 

[Marcelo Branco]

Hmm, Works but when I amended A4 to "Pink", the CF was applied in F5 ! LOL... Weird. It's comparing -1 row...

[TABLE="class: grid, width: 646"]
<tbody>[TR]
[TD]Column1[/TD]
[TD]Column2[/TD]
[TD]Column3[/TD]
[TD][/TD]
[TD][/TD]
[TD]Column1[/TD]
[TD]Column2[/TD]
[TD]Column3[/TD]
[/TR]
[TR]
[TD]Yellow[/TD]
[TD="align: right"]6[/TD]
[TD]Banana[/TD]
[TD][/TD]
[TD][/TD]
[TD]Yellow[/TD]
[TD="align: right"]6[/TD]
[TD]Banana[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD="align: right"]5[/TD]
[TD]Cherry[/TD]
[TD][/TD]
[TD][/TD]
[TD]Red[/TD]
[TD="align: right"]5[/TD]
[TD]Cherry[/TD]
[/TR]
[TR]
[TD]Pink[/TD]
[TD="align: right"]10[/TD]
[TD]Berry[/TD]
[TD][/TD]
[TD][/TD]
[TD]Blue[/TD]
[TD="align: right"]10[/TD]
[TD]Berry[/TD]
[/TR]
[TR]
[TD]Green[/TD]
[TD="align: right"]50[/TD]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[TD]Green[/TD]
[TD="align: right"]50[/TD]
[TD]Apple[/TD]
[/TR]
</tbody>[/TABLE]

Not weird at all! Because it seems that your data, in this example, begin in row 2 (A4=Pink).
So, try
Select F2:H5
and use this formula
=A2<>F2

M.