Add a conditional format for each use of a colour.
=VLOOKUP(B2, NameColours, 2, FALSE) = "Yellow"

NameColours is a 2 column range:
Bob Red
Carol Blue
Ted Yellow
Alice Blue

Cheers,
Rob



On 14-Dec-2009 12:59, Tracey wrote:
I have a separate tab for each store that lists it's personnel and their
ratings. I have then summarised all of this info on another sheet using
vlookup. I would like this final spreadsheet to colour code each cell
according to their rating i.e.

Position Store1 Store2 Store3 etc
Manager Bob (red) Carol (blue) Ted (yellow)
Meat Mgr Alice (blue)
Bakery Mgr