On my previous thread it showed the foloowing code I placed in each cell. =IF(ISNA(MATCH(Joshua!B25& Joshua!E25,'Week 47'!$B$2:$B$498&'Week 47'!$E$2:$E$498,0)),"",INDEX('Week 47'!$A$2:$E$498,MATCH(Joshua!B25& Joshua!E25,'Week 47'!$B$2:$B$498&'Week 47'!$E$2:$E$498,0),1)). To much time is wasted. I need to cover from A25 thru E724 on all 10 worksheets(each worksheet has a different name on the tab) and color code the cell "A" on the master worksheet(Week 47) once the match is found. The master worksheet changes each week. If more info is needed, let me know. Thanks for all the help in advance!!!!