Results 1 to 2 of 2

Thread: barcode scanner - finds certain data then highlights that cell

  1. #1

    barcode scanner - finds certain data then highlights that cell



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I'm using a barcode scanner to account for an inventory. I have an excel file of what I should have and account for each year. I would like to use the barcode scanner to scan a serial # on a particular item, then find that same # in the excel document, then highlight that cell. This has to be possible, I just do not know how to set up the document to do this. Can anyone help?

  2. #2
    Hello, what I do is to create a list of codes. Then I use the conditional formatting tool, click in Highlight Cells Rules, then Equal To and in the box select the cell A3 where you are going to put the code that you read. You can tried with each number that you have in the database. If you have any question, tell me.

    Workbook2.xlsx
    Microsoft Excel Massive Open Online Course.
    Learn all about Microsoft excel in this Online course, with video tutorials, examples of applications and a complete functions and buttons explanation.
    Be part of our community and enjoy learning Excel.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •