Excel 2007 : date/color coding question

You need three separate conditional format formulas applied to A1:

=MONTH(A1) =MONTH(NOW())-1
=MONTH(A1) =MONTH(NOW())
=MONTH(A1) =MONTH(NOW())+1

Select A1,
Select Conditional Formatting, New Rule
Choose "Use a formula to determine which cells to format"