XL 2007 acting out ?

X

XLFanatico

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
 
M

MartinaPa (MCT)

Excel counts days, therefore is year in dates important. Yes, change your year.
 
X

XLFanatico

MartinaPa (MCT) said:
Excel counts days, therefore is year in dates important. Yes, change your year.
Click to expand...
However, an old file xl 03 does not behave the same and reconize next month
eventough is next year.
 
Top