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.
1
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.
1