How to set multiple colors to words in single cell when character matched?

Hi

I would like to change the word colors of C into multiple colors, results as in Column G, when the characters match column A value, the characters will change to the same color as in A,

Using Macro or possible with Conditional Formating?

Thanks


Book2.xlsx