title: Find function automatical highlight different column permanantly
body: <p>I am trying to simulate a Good Receipt process with Google sheets.
  I have tried multiply options with conditional formatting, but i actually think, this is not possible.</p>
  <p>What i am trying to achieve:
  I scan a barcode in the &quot;Find&quot; box on top of my sheet.
  The sheet automatically marks rows who have that number.</p>
  <p>And now the tricky part.
  I now need in row A - the field automatically marked as &quot;Recieved&quot;, for all rows, where that Barcode number was found.</p>
  <p>here you can find the sheet which I am working with.
  <a href="https://docs.google.com/spreadsheets/d/1txDg_azE6ew87ljDo6IwkmSWEehGHWo6yTlMRjZCQVU/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1txDg_azE6ew87ljDo6IwkmSWEehGHWo6yTlMRjZCQVU/edit?usp=sharing</a></p>
  <p>Column: PkgID (C) &amp; BOL (R) are mostly the numbers I have to scan</p>
  <p>Is there any way to integrate this with the find option?
  Thank you</p>