XL 2007 acting out ?

  • Thread starter Thread starter XLFanatico
  • Start date Start date
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
 
Excel counts days, therefore is year in dates important. Yes, change your year.
 
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.
 
Back
Top