Forum Discussion
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
1 Reply
Select entire list1, Home->Conditional formatting->New rule->Use formula..
and use
=ISNUMBER( MATCH($B2, list2, 0) )assuming list1 starts from B2
