Add different colors to text in the same column

I have 4 columns, Employee 1, Employee 2, Employee 3 and Employee 4

I am going to create a new column which has all the names in the 4 columns.

Is there a way I can color Employee 1 as Green, Employee 2 as Red, Employee 3 as Blue etc in the New column which I have created?

(1) Answer

Login