I have list of item code in text file.
In Excel sheet, there are thousands of item code and related data.
I need to change the color of the background of particular cell of the item code , if that item code is in the text file
.
As there are hundreds of item code in text file and thousands of item code and data in Excel sheet, scanning each on text file and updating each on excel sheet will be very time consuming.
Any tips to solve this quickly?