Conditional formatting : Reference a list of names to change cell color.

Hello,  Im in the process of redesigning a roster that involves employees from a number of different contractors.  I have all employees on a seperate page seperated into columns based on the co...