Conditional formatting for dates in Excel 2007 — that’s not right?!

If you use conditional formatting with Excel 2007 to highlight dates, then you may be in for a surprise in December or January. The conditional formatting with “dates occurring” does not always produce correct results when the year changes. Excel 2007 does not recognise that January follows on December or that December precedes January. A [...]