Change multiple cells color based on cell value

[DriveByBBQ]

I've built a financial modeling stencil that is used for underwriting. The stencil has tables, charts, and exhibits that are imported into the finished word doc. We use the stencil for multiple clients with varying color schemes. I'd like the background colors of specific cells through out the workbook to change based on the value selected from a drop down box. I've already formatted and populated the drop down box with the client list, I just want to change the colors simultaneously to cut down on the monotonous task of selecting each cell and changing the color. Hope I articulated that clearly. Also, there's only one color assigned to each client. Thanks for any help.