Well, I was able to do it in Excel 2010, even over all those other conditional formats. What is it you tried? This worksheet doesn't seem to include your attempt at the date highlighting.