Compare columns in different worksheets nad highlight differences

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.

Mike!

Please Login or Register  to view this content.

I could not see where the word "result" comes from. Was meant to be "c"?

Enter this equation =IF(ISERROR(MATCH(A1,Sheet2!B$1:B$3000,0)),TRUE) in a new column in the first cell of the big sheet then copy it down. Use a filter to show just the values that say true. Select them, change the color. Show All.
A1 is the big sheets email column (note, column. use 1 for the row). No $ signs.
B$1:B$3000 is the small sheet's email. (change 3000 to whatever the last row is. Need the $ for this field)

"c" appears to be the column that contains the email address on the large sheet.
"F" is the column for the small sheet (other).
Looks like he already fixed the "Result" part

Yes,he did

Works like a charm Many thanks, Mike!!!!