Problems shading multiples cells with a key link.

[Sanorah]

I have one workbook with multiple worksheets. Half of the worksheets are labeled “Sunday-Saturday”, the other half is “Sunday Dock Walk-Saturday Dock Walk”. The “dock walk” sheets go out and fetch data from the corresponding work day sheets. What we need to have happen is that for each of the “dock walk” sheets in cells under the C-F columns, anytime data is entered in column I (time finished) on the corresponding work day sheet the cells under columns C-F in the “dock walk” sheets need to turn gray. Example- on the “Sunday Dock Walk” cells C2:F3 need to turn gray when on the “Sunday” sheet time is populated in cell I 11. I’ve been able to get this part done with a conditional formatting formula of
=OFFSET(Sunday!$I$11,INT((ROW(B2)-1)/2),0)<>"". The problem is that the actual field “dock door” must match up first. Example- on “Sunday Dock Walk” the dock door is located under column B. On the sheet “Sunday” it is located on the column F, but they are not in numeric order on the “Sunday” sheet. I tried using this formula in conditional formatting =VLOOKUP(INDEX($B$2:$B$49, 2*INT(ROW($B2)/2)-1), Sunday!$F$11:$I$113, 4, FALSE)<>"", but it did not work. I’m thinking it might have to be done with a macro which I am not very good at.