I have two sheets keywordsheet2 and sheet1.

keywordsheet2 has multiple keywords with color in multiple columns /rows with any characters and space.

I need help to find, compare and color partially matching fonts (up to 3 characters) in Sheet1(in multiple columns/rows) with multiple keywords given in keywordsheet2 using Excel Macro.