Find matching glossary text in an Excel table and Word document for Mac software and effect desired changes in both files

Example files provided: I need a looping macro or subroutine(s) to examine the second column of string text entries in an Excel table of 7 columns and 1009 rows and, if the sixth column entry in the row being tested = 0 (meaning untested), then test each string text row entry in the second column for the first occurrence only of an identical string text in the body of text of a separate Word document. The text tested in the Word document should only include font sizes of 10 or 12 and have an initial font color of all black characters. Additional columns in the table of significance for this subroutine are the string text in column 5 which identifies related row entries for possible exclusion from testing, columns 6 and column 7 which track and use number codes to define status of rows tested (column 6 for a single Word document file; and column 7 for cumulative multiple files from a specific volume of files) The numerical codes for columns 6 are: 0 = not yet tested; 1 = tested as true; 2 = tested as false; 3 = common key word in column 5 exists in another row that tested true and no further test is required for all matching fifth column entries for those rows); and column 7 which tracks status for multiple files for a given volume of files and uses the same codes used in column 6... Therefore, If an exact match for the tested string text of the second column of a row is found as true, the font color of the string text in the Word document should be changed from black to turquoise (RGB 0,176,240) and, additonally, the contents in the Excel table of columns 6 and 7 of the row being tested should be changed to reflect the new status from default code 0 to 1 to indicate "true" for an exact match; Additionally, where there is an exact match = true, an intermittent looping subroutine should be called to test the current row that has tested as true for the presence of a "keyword" with a text length >1 found in its fifth column of string text; If the length is > 1, then other rows will have matching fifth column entries, and for all other of the 1009 rows with a matching fifth column text string entry, those rows should be excluded from further testing by changing the code in column 6 from its default of 0 to 3 to indicate no test is required as there is already a "true test" for a related row entry. Column 7 entries cumulative file tests should reflect codes of 1 for exact match found = true and 2 for exact match found = false. There are a total of 585 Word documents that must be tested, so a copy and paste will be done manually to replace the text in the Word document file and the column 6 entries in the Excel table will be restored to the default 0 for each ensuing test before the macro is run again. The existing changed entries in column 7 will be retained until all files of a specific volume of files have been tested. Saving of modified Word document text files after being tested will be saved manually.

The project is designed to highlight specific glossary terms from an Excel table and find the first occurrence of any of them in a target Word document. The target Word document will be used for all subsequent files that need to be tested by doing a copy and paste to replace the Word document to be tested. The Word doc file samples show a 'before' and 'after' of desired results. The columns in the Excel file table have headings that should be self explanatory.