Taking Inventory with Excel

Can anyone tell me if Excel 2010 can do this? I have no experience with macros and vba if it comes to that.

I have a spreadsheet with a list of books in the order in which they should appear on the shelf. I would like to take a barcode scanner and scan each book. I would like for Excel to find the matching barcode and then format that matching barcode differently (different font color or different fill color). When I am done with my inventory, I would like to be able to filter on the different format so that all that remains are the missing books (those that weren't scanned).

I have tried conditional formatting with a formula, where the cell where I'm inputting the barcode equals any cell from the column where the barcodes are stored. This works great initially, but each successive barcode removes the conditional formatting from the prior barcode. I understand that is how conditional formatting is meant to work, but I need something more permanent. If only I could make the conditional formatting stay ....

I've tried find and replace where I am replacing the "found" barcode with only a different format. This sort of works, but is EXTREMELY clunky. It requires pushing the enter key (even though the barcode scanner is programmed to end with a carriage return) and resetting the cursor into the find box with every scan of a barcode.

Is there a way to accomplish this process in excel? Thanks for any helpful hints.

14goldenz