Hello,
I'm currently using this formula:
"=IF(LEN(G1)9,CONCATENATE(VLOOKUP(VALUE((LEFT
(G1,2))),$AA$1:$AB$25,2),(MID(G1,3,6)),"-",(RIGHT
(G1,2))),CONCATENATE(VLOOKUP(VALUE((LEFT
(G1,2))),$AA$1:$AB$25,2),(MID(G1,3,6)),"-",(RIGHT(G1,1))))"
to scan barcodes into a cell, that converts to i.e.
A123456-7. It works well, and I have conditional format to
colorize any duplicate value, if any (formula is= IF
(COUNTIF($1:$65536,A1)1,TRUE,FALSE). My problem is that
this process is registering the new value and is thus
incrementing my file
I would like now to scan these barcodes into a dialog box
that will then also colorize an existing value, but
without registering the value entered into the dialog box

Any idea?
Thanks
Bernard