select all the rows from 2 onwards till the end of your data, go to format,
conditional formaating. Sleect "Formula Is", and enter the following formula
in the box:
=month(A2)<>month(A1)
and click format, patterns tab, and select a color.
Assumption. The dates are in column A
Mangesh
