Eliminate rows without matching serial numbers

Question

List of 82 serial numbers in Sheet1 col. "C". Want to check it against 229 serial numbers on Sheet2 col. "E".

Want to highlight red on Sheet2 for all rows without a matching SN from Sheet1.

Easy way to do this?

Trying to avoid manual input.

Answer 1

With conditional formatting you can achieve this:

The formula in the Format values where this formula is true: (adjusted to your tables)

=ISERROR(VLOOKUP($E1,Sheet1!$C:$C,1,FALSE)) *

Applies to: =$1:$229

* Mod based on BigBen comment.