VBA combination columns lookup in another sheet.

[jakobt]

Have a sheet1 with:
column A: with names
column B: with schools

In sheet2 I have:
column A: with names
column B: with schools

I want to look up the combination of A&B in each row in sheet 1 and colour them green if they are available in any row in sheet2.

I want to do it in vba as I also want to add a few other Or criterias later

 

[Fluff]

Glad to help & thanks for the feedback