Need to highlight matching rows (or) non matching rows

[signup]

Hi,

In my excel, i have two sheets.

• in sheet1, i have three columns with almost 3000 rows.
• in sheet2, i have two columns with 230 rows.

sheet2 was like a child sheet, all these data exists in sheet one. i need to exclude non matching data from sheet one.

the condition i have is, two columns in sheet2 should match with first two columns in sheet1.

Example: Sheet1
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Table[/TD]
[TD]Column[/TD]
[TD]Data Type[/TD]
[/TR]
[TR]
[TD]Emp[/TD]
[TD]Sal[/TD]
[TD]Number(5)[/TD]
[/TR]
[TR]
[TD]Emp[/TD]
[TD]EmpNo[/TD]
[TD]Number(4)[/TD]
[/TR]
[TR]
[TD]Dept[/TD]
[TD]Loc[/TD]
[TD]Char(10)[/TD]
[/TR]
[TR]
[TD]SalGrade[/TD]
[TD]Ename[/TD]
[TD]Char(20)[/TD]
[/TR]
[TR]
[TD]Account[/TD]
[TD]Id[/TD]
[TD]Number(5)[/TD]
[/TR]
</tbody>[/TABLE]
Sheet2:

[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD]Table[/TD]
[TD]Column[/TD]
[/TR]
[TR]
[TD]Emp[/TD]
[TD]Sal[/TD]
[/TR]
[TR]
[TD]Dept[/TD]
[TD]Loc[/TD]
[/TR]
</tbody>[/TABLE]



If both Table_Name and column_name from sheet2 is equal to table_name and column_name from sheet1 then it was a perfect ma.
i.e. Sheet2(Table_name.Column_Name) = Sheet1(Table_Name.Column_Name)

finally i need non matching data..

Required Output is:

Sheet2:

[TABLE="class: grid, width: 250, align: left"]
<tbody>[TR]
[TD]Table[/TD]
[TD]Column[/TD]
[TD]Data Type[/TD]
[/TR]
[TR]
[TD]Emp[/TD]
[TD]EmpNo[/TD]
[TD]Number(4)[/TD]
[/TR]
[TR]
[TD]SalGrade[/TD]
[TD]Ename[/TD]
[TD]Char(20)[/TD]
[/TR]
[TR]
[TD]Account[/TD]
[TD]Id[/TD]
[TD]Number(5)[/TD]
[/TR]
</tbody>[/TABLE]






please help me with this.