Thread: Prior Month
View Single Post
  #1   Report Post  
Howard
 
Posts: n/a
Default Prior Month

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