Forum Discussion

pcosta01's avatar
pcosta01
Copper Contributor
Jan 17, 2023

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

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 😄 

excel
Formulas and Functions
office 365

1 Reply

  • XXplore's avatar
    XXplore
    Brass Contributor
    Jan 17, 2023

    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)

Resources