I have a rather complex spreadsheet that I would like to automate. I'm sure
it can be done, just not sure how.

My workbook has 3 sheets, the first is a schedule broken up into blocks,
left to right the blocks are labled by the day of the week (Monday,
Tuesday...) Top to Bottom labeled by the week number (1, 2, 3, 4 ,5).

With in each block is a list of People (Smith; Doe...) and related elements
(Room, %, Start Time).

The Second sheet is a mirror of the first, data is linked to the first.
This allows me to apply color coding without impacting the appearance of the
first sheet. If my conditional formatting works this sheet would be
eliminated.

The third sheet is a key, contains a list of names from the first sheet and
a corresponding Index Color ie Smith 22

My goal is to apply the related index color to all instances of smith that
appear on the first sheet where the % is greater than 0.

The color would only be applied to Name, Room, % and Start Time Field within
a given block.

Example:

Smith appears in the 1 Monday, 4 Friday and 2 Tuesday Blocks. I want each
instance to be colored the same ( the % field would be populated for each
instance).

I would attach the file to this posting, but that doesn't appear to be an
option.

I'm pretty sure this would require VBA code which I'm comfortable with.