Find function automatical highlight different coloumn permanantly-CodePudding

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.

What i am trying to achieve: I scan a barcode in the "Find" box on top of my sheet. The sheet automatically marks rows who have that number.

And now the tricky part. I now need in row A - the field automatically marked as "Recieved", for all rows, where that Barcode number was found.

here you can find the sheet which I am working with.

and you will replace it with:

$1

take extra notice of the invisible character after $1

you can get it by running this formula and copy it from the middle (after you enter the cell)

={"", "﹀﹀﹀﹀﹀﹀﹀", ""; 
 ">>>>>>>>>>>>", CHAR(32), "<<<<<<<<<<<<";
 "", "︿︿︿︿︿︿︿", ""}

next, you can go to conditional formatting and use:

=REGEXMATCH(C1, CHAR(32))

CodePudding user response：

To mark the field as received, you can use this script. You will get a new menu. Then scan the number within the inputbox ...

function onOpen() {
  SpreadsheetApp.getUi().createMenu('⇩ M E N U ⇩')
    .addItem('