I have 2 lists of code. How to use conditional formatting to highlight code in List 1 which appear in List 2 if the first 3 characters in List 1 match with List 2.
List 1:
A01
A02
A0876
B89
B764
C7821
C54
C09
D349
D76
E456
G39
Y467
Y32
Y7834
List 2:
A08
B89
C09
D34
Y78
Thank you for your help!
Bookmarks