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