Use conditional formatting to highlighting cells based on Name

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 contractor.

EG
A1 - Business 1
A2 - Employee 1
A3 - Employee 2

B1 - Business 2
B2 - Employee 1
B3 - Employee 3

and so on.


On the roster sheet i would like the cell where names are inserted to automatically change color depending on what business they are from

Eg

24/10/17

B2 Employee1 (Turn Green)

25/10/17

B1 Employee 5 (Turn Orange)


my Issue is that i cant make the conditional formatting reference to an entire column on the other page (B1 through to B17 for example) without getting errors.

How would i go about this?

Kind regards,