Change FONT color based upon a list of items

First Macro-
I have a list of anywhere from 1-500 items that are in an Excel list ie (TTT45.HE65, KNM11STE, SGE.90.76.DS). I need to find those items in another spreadsheet and turn the FONT RED. However, there will be other items in the same cell that need to remain Black. I need teh cell background to remain teh same - I only need the Font of the items in my list to change

Second Marco – I need to delete all the items I made red and have normal spacing around the items where they were removed from

Upload a sample workbook showing before/after, so that we can work.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.