I have two spreadsheets created by two people who were documenting equipment serial numbers within our company. Each person was supposed to track their own respective product but, we believe they tracked some of the same serial numbers.
How do i "quickly" determine if the same serial numbers are present within both spreadsheets? (Each spreadsheet contains approx. 600 serial numbers). I would like to show the similar serial numbers with a highlight or bold font if possible. Can this be done with Conditional Formatting?
Thx,
Noir
How do i "quickly" determine if the same serial numbers are present within both spreadsheets? (Each spreadsheet contains approx. 600 serial numbers). I would like to show the similar serial numbers with a highlight or bold font if possible. Can this be done with Conditional Formatting?
Thx,
Noir