View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 468
Default Shading cells whenever they change Months

Are your 3letter Months Text or Formatted dates?

"Loadmaster" wrote:

How do I conditionally format a cell that whenever the cell Changes to Jan,
Mar, May, Jul, Sep or Nov shades €śBlue€ť and every other month in between
shades €śGreen€ť?