Forum Discussion

i_FranciX's avatar
i_FranciX
Copper Contributor
Sep 21, 2023

Highlight number that are in another list

Hi,

 

i'll try to explain in my bad english.

I have a list of product number. I have another list where there are only the unique number from the general list product. How can i highlight the number of the general list to verify if in the unique list all the numbers are reported? I'm on office 2016

 

General list 

 

 

List with only unique number

 

 

 

excel
Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 21, 2023

    i_FranciX 

    Select entire list1, Home->Conditional formatting->New rule->Use formula..

    and use

    =ISNUMBER( MATCH($B2, list2, 0) )

    assuming list1 starts from B2

Resources