If range A2:C26 contains data, and column A (Batch ID) has hyphenated data with a two-digit code to the left of the hyphen and a 4-digit code to the right of the hyphen in column A.
The first letter of the Batch ID is known as the Identifier and the leading number of the 4-digit code to the right of the hyphen is known as the Key.


For example, in the Batch ID "N9-363B", the Identifier is "N" and the Key is 3:

How do I create a subroutine that allows me to select the Identifier from a drop-down menu in cell F2 and the Key from a drop-down menu in cell F3 and any rows of the data (columns A, B, and C) whose Batch ID meets those criteria to be highlighted GREEN.

Please, help us to help you, attach a workbook with this in.

Dear p45cal,

Thanks for your willingness to help.
Please, find the attached workbook for your further action.

Attached Files

SAMMY.xlsx (9.9 KB, 2 views)

Have you posted the right workbook? It doesn't seem to relate at all to your query:


2023-04-22_112511.png