Using a reference table to cycle through a pivot table

[Duchesssix]

I am looking for some direction in how to use a reference table (containing names) to cycle through an existing pivot table and changing the color of the row for names that are found in the reference table.

Currently I have a mind block in how to accomplish this effieciently. Currently I use a CASE statement but the use of a reference table is more dynamic for personnel changes. Names can be added/removed as needed where as a CASE statement is hard-coded and requires the programmer to change.

I am currently using EXcel 2010 VBA.

Any push in the right direction will be greatly appreciated.

Thanks,
Dawn