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