Copy Conditional Formatting color from one sheet to another

[Maldai]

Hi,

I found this rather neat calendar template online and my manager wants me to link the background colors of the month sheet tabs to the first main year sheet tab. If you look at the Sheet 1 the 3rd day is conditionally formatted to blue because it contains the value "B" which means that on sheet "Year" February 3rd should have a background color of blue also.

However, when it reaches the following line, I receive a very generic 400 error. I am somewhat certain I have the other logic mostly worked out.

Sheets("Year").Cells(tempRowNum, tempColNum).Interior.ColorIndex = Sheets(MonthSheet).Cells(MonthWeekRow, MonthWeekCol).Interior.ColorIndex

Do I have the syntax wrong? I feel like I'm missing something very obvious.

Please Login or Register  to view this content.