color every nth row in excel
<p>I understand (in a limited way) how to use conditional formatting in Excel 2010.
I have a calendar type of display across many columns, in one row, like this:
1 2 3 4 5 6 7 8 ...
I want to color 2 days green, 2 days red, 2 days orange, 2 days blue, then repeat.
I could do it manually, but I'd like to make a calendar that displays more than just this year. Leap years change the format, the 1st doesn't always come on Monday, etc.
Is there a way to do this with conditional formatting so that when the calendar updates, the colors do as well?</p>

<p>Each day/date occupies a single cell.</p>