Shading cells whenever they change Months

[Loadmaster]

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�

 

[JMay]

Are your 3letter Months Text or Formatted dates?

 

[Loadmaster]

Yes, with CAP LOCKS on.

Are your 3letter Months Text or Formatted dates?

 

[Loadmaster]

3 letters ie JAN MAR MAY

Yes, with CAP LOCKS on.

 

[JMay]

Using C/F try FormulaIS and enter:
Condition 1:
=ISNUMBER(FIND(A1,"JANMARMAYJLYSEPNOV"))
your color of choice

Then ADD a second Condition and enter
Condition 2:
=NOT(ISNUMBER(FIND(A1,"JANMARMAYJLYSEPNOV")))
your color of choice..

 

[Loadmaster]

Thank-you very much it worked, I used JUL vice JLY LOL

 

[Loadmaster]

One last condition to these cells, how do I set condition 3 to if cell is
#N/A to stay white?

 

[Loadmaster]

Its ok, I just figured it out. I just used the Opposite for condition 2 for
eg. =ISNUMBER(FIND(E2,"FEBAPRJUNAUGOCTDEC"))