redfuse,
Attached is an example workbook based on the criteria you described.
It has two sheets, 'Sheet1' and 'Allowed Words'
In 'Allowed Words' column A is the list of allowed words
In 'Sheet1' column A is the list of data (text strings) and there is also a button labelled "Find Disallowed Words" which is assigned to the following macro:
That code will color disallowed words red. You will probably need to adjust rngData to be the actual range you want the code to search through. Does that work for you?
Bookmarks