I have an Excel spreadsheet, which is setup like a calendar. I can change the year at the top and the corresponding dates change in the days of the week columns. So, Monday thru Saturday are showing from E5:T5 and all the remaining rows are below. So, Monday is Merged in E5:G5, blank cells in E6,F6,G6, Date merged in E7:G7, two information merged cells in E8:G8 and E9:G9 and then individual cells in E10,F10,G10 thru E13,F13,G13. Tuesday is then in HIJ, Wednesday in KLM thru Friday in QRS and Saturday is then in T...Sunday is hidden in BCD. Then the pattern repeats for the entire year from row 6. The days of the week stay in row 5. What I would like is if the first six letters = "Closed" in the merged cells of row 9, 17, 25, 33, 41, 49, 57, 65, 73, 81, 89 up to 577 going up by 8, then the three columns and four rows below would be formatted in the light green color. So, if E9:G9 = "CLOSED MLK", then Cells E10,F10,G10 thru E13,F13,G13 would conditionally format to the light green color. This would repeat for each day of the week and all the way thru the end of the calendar in row 581. I can post an example if that helps? Just trying to keep from doing individual conditional formats as I change the year of the calendar...Any help would be appreciated...