I have an excel filled with over 5000 cells of names, i also have a folder with over 10000 names of PDF files, i need to know which one of the names in the cell exists in the folder.
i'm looking for a script to go one cell at a time (all in one column) and highlight\bold\any other modification to that cell so i'll know that it's located in the folder.
*Note, the cell only contains part of the PDF name, (e.g. cell name = XXX, pdf file name = a-xxx.pdf) a windows search finds it without problems
any scripts for that? i've tried to google it but i couldn't find a script to highlight the once found, only to move the files to another folder but that would require the exact name in the cell.