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	Column	Data Type
Emp	Sal	Number(5)
Emp	EmpNo	Number(4)
Dept	Loc	Char(10)
SalGrade	Ename	Char(20)
Account	Id	Number(5)

<tbody>
</tbody>

Sheet2:

Table	Column
Emp	Sal
Dept	Loc

<tbody>
</tbody>

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	Column	Data Type
Emp	EmpNo	Number(4)
SalGrade	Ename	Char(20)
Account	Id	Number(5)

<tbody>
</tbody>

please help me with this.