How to make importing matching serial numbers Highlight a line?

[rockdude]

Looking for some help?


I have a spread sheet with approximately 500 line entries that include
(Make, Model, Serial Number, etc..)

I want to take my monthly list of serial numbers from another source
and apply them to the current spreadsheet so that the line items would
automatically light up “yellow” so to be easily recognized.

I don’t want duplicate entries. I just want to make my monthly report
serial numbers cause the master report to highlight those lines that match the serial numbers. (Would be nice if I could change the color as well for successive months)

Any help or ideas would be appreciated.

Thanks in advance.