Compare two columns in two different spreadsheets and Highlight difference

Hi shilloh

1) You can do it, using a helper column(that you can hide it, if you like) and using countif & if&and functions.

=IF(AND(Sheet2!$A$2:$A$8=A2;Sheet2!$B$2:$B$8=B2);COUNTIF(Sheet2!$B$2:$B$8;B2);"")

Then in column b, use a simple conditional formatting.

2) In column C(Sheet2) use the formula:

=IF(A2<>Sheet1!$A$2:$A$8;"NEW ENTRY";A2& "EXIST IN Sheet1!")

You can add a conditional formatting if you like to it!

Hope to helps you.