I have a workbook "Schedule" that Sheet1 is renamed to "Staff". I have a cell range named "Holidays located at cell K2 to K13 that Holiday dates are entered. I have several sheets that will be the staffs schedule starting with Sheet4 thru Sheet40. I need a formula, vba code to change the color of each cell (dated) corresponding with the Holiday date listed on Sheet1 "Staff" to each of the staff (sheet4 thru 40). IE: MLK day entered on "Staff" sheet one will color 1/16/12 for each sheet4 thru 40.
I've attached the file for review.
Bookmarks