Finding a batch of numbers from one file on another without sear

Resolved · Urgent Priority · Version 2016

Tue 2 Feb 2021, 13:51 Delegate Daniel said...

Daniel has attended:
Excel Introduction course
Excel Intermediate course
Finance for Non-Financial Managers course
Excel Advanced course
Excel Advanced - Formulas & Functions course
Excel Intermediate course
Excel Advanced course

Finding a batch of numbers from one file on another without sear

Hi. I have 2 excel files. One with 4500 lines and the other is 225 lines. The 225 lines has a long number which i need to match and colour red on the large 4500 file. I can obvioulsy filter one by one and search but i was hoping there is a way to do it in 1 go?

Wed 3 Feb 2021, 11:23 Trainer Jens said...

RE: Finding a batch of numbers from one file on another without

Hi Daniel,

Thank you for the forum Question.

If you have a high level of VBA knowledge you can write VBA code, which can do what you want, otherwise you will need to copy the 225 lines and paste them in the same worksheet as the 4500 lines.

Select the long number column you want to pair in both lists. On the Home tab click conditional formatting -> Highlight Cell Rules -> Duplicate Values

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector