Hello again, I have one finall question

I need to set up a sheet that is smart enough to find NAMES in column A (ex. VISA, MASTERCARD, American Express, etc.) then change their cell color to a specific color that I assign for each name

So if someone later on adds the word VISA in a new cell in this sheet then automatically that cell becomes blue, if they enter MASTERCARD then the cell turns Green and so on ...


Thank you