Good Afternoon Guys ,
I'm encountering a difficulty whereby I have two string texts in two different cells for eg.

Cell A1 : [RMB101,RMB102,RMB103]
Cell A2 : [RMB102, RMB105, RMB107]


How do I only highlight the recurring entry which is RMB 102 ? Your help is greatly appreciated , and can the formula be used across the worksheet. Thanks & Regards.