i have been searching for a while on how to do that, and there is indeed pretty much information available online, but nothing in particular helps my case.

So this is what i am trying to do:
i recieve on a daily basis two different excel workbooks - one is about 300 rows, and the other 100, with different number of columns .i copy/paste them in a brand new workbook as different sheets.
The only thing that may make a match is a column with email address. It is present in a column in both spreadsheets. What i need is to highlight the rows in the big spreadsheet that do NOT match the rows in the small one by email. Basically, highlught all rows that do not have a duplicate email in the other sheet. The email in the first sheet is column C and in the second one - F.
I could not make Vlookup to work as i do not have anything else to match except the email. No ther column is the same in both sheets.

Hope i was clear enough. Appreciate any assistance.