I am trying to copy conditional formatting in Excel 2007, but it doesn't seem
to work the same way that I remember in 2003. Or maybe I'm doing something
wrong.

I have a date in A1, which just displays the month. Then in B1:B31 I have
the numbers 1 through 31 for days of the month, and C1:C31, blank boxes for
data. If the month has less than 31 days, I want to "hide" the extra days by
formatting those cells blue to match the surrounding cells. For example, if
the month in A1 is Feb-2009, then B29:C31 should all have the special
formatting.

I started by selecting B31:C31, and in the conditional formatting dialog,
used the formula: =B31DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)
That seems to work well, but when I copy the format to the other cells, it
doesn't copy correctly.