| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 - change shading when selecting groups of cells | Excel Discussion (Misc queries) | |||
| IF statement to make cells change shading | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| How do i change 15 months to read 1 year and 3 months? | Excel Discussion (Misc queries) | |||
| shading certain months on time chart | Charts and Charting in Excel | |||
Hybrid Mode
