Looks a little too complex for my skills.

Hopefully someone else can give assistance.

Your first post looked easy enough but as you say, that was not your real
question.

Apologies for wasting your time.


Gord


On Wed, 13 Jan 2010 17:53:01 -0800, Tracey
wrote:

I have 4 sheets that detail a group of Stores and their Personnel by their
Jobs and the Performance rating for last year and a fifth sheet that
summaries all of this data

e.g.
Sheet 1 = Store 1

Col A Col B Col C
Manager Bob High Potential
Meat Mgr Carol High Value
Bake Mgr Ted Performance Manage

Sheet 2 = Store 2 etc

Sheet 5 summarises all of the other 4 to give a complete list for the region
via a link to each individual store sheet
e.g.

Row Col A Col B Col C Col D Col E
Store 1 Store 2 Store 3 Store 4
Row 2 Manager Bob Alice Goofy Daisy
Row 3 Meat Mgr Carol Mickey Clarabelle Tracey
Row 4 Bake Mgr Ted Minnie Donald etc

I need to format cells B2 through E4 based on their Performance rating in
Col C from their Store sheet.

High Potential = Blue
High Value = Yellow
Performance Manage = Red
Promotable Next Lvl = Green
Promotable Current = Light Green
Too Soon to call = Blank

I hope this makes sense... thanks for your time Gord.