Perhaps

=MONTH(M$4)=MONTH(TODAY())-1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Howard" wrote in message
...
How do I get the prior month to automatically conditionally format when
the
current month rolls around?
I have this formula in Formula Is =MONTH(M$4)=MONTH(TODAY()). That
highlights November. I need to highlight October instead, and when
December
rolls around, November will be highlighted.

Thanks,
--
Howard