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



"rajanku" wrote in message
...
I want change the color of a row when the date changes to next month by
software