Forum Discussion
EXCEL
HOW TO BULK FINDING FROM 1 SHEET TO ANOTHER SHEET i.e BKID0009547 FROM ONE SHEET TO BKID0009547 FROM OTHER SHEET WE HAVE 2 SHEET HERE AND IT GETS MORE TIME TO FIND ONE BY ONE WITH EACH OTHER PLEAS...
To highlight matching values: ( Conditional Formatting in Excel will help )
Let's Follow Along
Step1 - Select the column in Sheet1.
Step2 - Go to Conditional Formatting > New Rule.
Step3 - Choose Use a Formula and enter:
=COUNTIF(Sheet2!A:A, A1)>0
Step4 - select any formatting in this case pick color code