I have the need to read the values from an excel column and use each value to perform a search in a respective text file. Then highlight every value in column A in RED that is not found during the search of the text file? This way, after I run the macro I can simply do a filter on color in column A to show all those in red :) All the search values will come from the column A.
Because I want to use the values in column A to search a text file, I did not think I could use a standard VLookup, I may be wrong.
I would like to do this programatically within an Excel Macro using VB.
Excel File A
Text File A