Please how do I create a subroutine that allows the user 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 will be highlighted GREEN.
T3-238L 10/12/2017 10/19/2017
J9-488N 1/22/2018 1/29/2018
H3-107R 1/27/2018 2/5/2018
E6-104Q 2/13/2018 2/21/2018
C1-465A 3/1/2018 3/6/2018
N0-274O 4/27/2018 4/30/2018
A8-43I 5/17/2018 5/24/2018
C7-34N 6/9/2018 6/18/2018
T6-287Z 7/30/2018 8/1/2018
H2-479T 8/25/2018 9/1/2018
H4-17P 9/7/2018 9/11/2018
T4-491R 9/15/2018 9/21/2018
E8-240R 9/29/2018 10/7/2018
C3-24Z 11/27/2018 12/3/2018
N9-363B 12/16/2018 12/23/2018
T9-117W 2/24/2019 3/3/2019
C9-286N 4/6/2019 4/12/2019
H0-312Z 4/13/2019 4/18/2019
A8-302T 5/22/2019 5/28/2019
A6-329B 7/31/2019 8/5/2019
E6-185C 8/6/2019 8/13/2019
E6-359C 8/9/2019 8/16/2019
H0-410R 8/31/2019 9/10/2019
C0-283A 10/31/2019 11/4/2019
Bookmarks