I have a spreadsheet that is flooring diagram of our call center that populates employee names and extensions based on their seating location in the CC agent Database.xls spreadsheet.

I am looking to have the employee name cells in the (WIP) Seating Chart2.xls colored based on the supervisor they belong to through a vlookup formula. So I would need to pull information through the vlookup from CC agent Database.xls if the the vlookup formula matches supervisor I want the cell to be colored with the color assigned to that supervisor.

The spreadsheet is already colored, but as people move around this color scheme breaks down because it does not update unless done manually.
We have 5 supervisors so conditional formatting won't work with me. (we use XL03 at work)

I have made 2 different sheets for the Seating Chart because this chart is to be made available to the public and I do not want unnecessary fingers touching the main database.

Any help would be appreciated.

(WIP) Seating Chart2.xls
CC agent Database.xls