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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
