Shading cells whenever they change Months
 

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€�?

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€�?

Shading cells whenever they change Months
 

Yes, with CAP LOCKS on.

"JMay" wrote:

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€�?

Shading cells whenever they change Months
 

3 letters ie JAN MAR MAY

"Loadmaster" wrote:

Yes, with CAP LOCKS on.

"JMay" wrote:

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€�?

Shading cells whenever they change Months
 

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" wrote:

3 letters ie JAN MAR MAY

"Loadmaster" wrote:

Yes, with CAP LOCKS on.

"JMay" wrote:

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€�?

Shading cells whenever they change Months
 

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

"JMay" wrote:

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" wrote:

3 letters ie JAN MAR MAY

"Loadmaster" wrote:

Yes, with CAP LOCKS on.

"JMay" wrote:

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€�?

Shading cells whenever they change Months
 

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

"Loadmaster" wrote:

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

"JMay" wrote:

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" wrote:

3 letters ie JAN MAR MAY

"Loadmaster" wrote:

Yes, with CAP LOCKS on.

"JMay" wrote:

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€�?

Shading cells whenever they change Months
 

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

"Loadmaster" wrote:

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

"Loadmaster" wrote:

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

"JMay" wrote:

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" wrote:

3 letters ie JAN MAR MAY

"Loadmaster" wrote:

Yes, with CAP LOCKS on.

"JMay" wrote:

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€�?