| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL 2007 acting out ?
My formatting for dates for next month in my table are suppose to be GREEN,
however it does not format those dates GREEN. Does it have to do with the change of year? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XL 2007 acting out ?
Excel counts days, therefore is year in dates important. Yes, change your year.
"XLFanatico" wrote: My formatting for dates for next month in my table are suppose to be GREEN, however it does not format those dates GREEN. Does it have to do with the change of year? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XL 2007 acting out ?
"MartinaPa (MCT)" wrote: Excel counts days, therefore is year in dates important. Yes, change your year. "XLFanatico" wrote: My formatting for dates for next month in my table are suppose to be GREEN, however it does not format those dates GREEN. Does it have to do with the change of year? Thanks However, an old file xl 03 does not behave the same and reconize next month eventough is next year. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel acting up | Excel Discussion (Misc queries) | |||
| Excel 2007 formulas acting weird | Excel Discussion (Misc queries) | |||
| Help...my charts are acting up! | Charts and Charting in Excel | |||
| EXCEL 2007 acting up | New Users to Excel | |||
| Paste is acting up | Excel Worksheet Functions | |||
Linear Mode
