I have a worksheet that is an import of a text file of a directory listing. I'm using Get External Data to bring that file into the worksheet. I "mark" certain files on that listing when they've been handled. The contents of that directory change periodically. My initial marking method was "bold = handled," the problem is that when the data is refreshed from the text file, if there's new information, the information moves, but the formatting doesn't. I then tried placing a mark in an adjacent cell, but when the new information is inserted upon refresh, the adjacent cell with the mark doesn't move because it isn't part of the data range, so the "insert cells" or "insert entire rows" options don't apply.

Example: File names imported are ABDE, where D has been handled.
A
B
D
E

Upon refresh, file C has been added to directory. C is inserted after B, moving D & E down, but the bold formatting on D stays in the cell previously occupied by D, and is now applied to C, thusly:
A
B
C
D
E

Similarly, if B in the first example is removed, upon refresh D & E move up one cell, and the bold formatting is now applied to E.

Any help, or suggestions of an easier way to accomplish my goal would be greatly appreciated. I've spent about two hours tonight doing web searches trying to figure this out; at least half that was on this forum alone, with no luck.