Highlighting rows with specific values from a list of ID's

Copper Contributor

Hello! 

I need to highlight a set of values (column A) from a list of ID's (Column B). All I want to do is highlight the value. I have tried using conditional formatting to highlight duplicates but there are duplicates in column A that don't match column B.

 

Below is an example: 

DataID's
NGL_G0542AVE_G0005
NGL_G0543BXA_G0052
NGL_G0553BXA_G0461
APD_G0300BXA_G0554
APD_G0335BXA_G0532
APD_G0378BXA_G0660
APD_G0400BXA_G0521
APD_G0418BXA_G0630
APD_G0450BXA_G0371
APD_G0451GRW_G0050
APD_G0455BXA_G0417
AVE_G0005CHI_G0003
BXA_G0052CHI_G0088
BXA_G0461CHI_G0031
BXA_G0554CHI_G0043
BXA_G0532CHI_G0063
BXA_G0660EOA_G0150
BXA_G0521LWD_G0050
BXA_G0630EOA_G0047

 

Thanks in advance :D 

1 Reply

@pcosta01 
Say Data in column A1:B20
Select A2:A20, Conditional Formatting -> New Rule -> Use a formular.. -> Edit the Rule Description
=IFNA(MATCH($A2,$B$2:$B$20,0),FALSE)