Hello,
I suppose that you "job allocated" field is linked to a "user" table with each user name as primary key.
In this "user" table you can add a single select field "User Tag" which repeats the user name information and assigns a color to each user.
You can then add this column in your "job table" as a lookup field.
Regards
Pascal