I want to conditional format dates that have occurred in the past but not the current date. Is there a way that I can do that in Excel 2007? I've tried the "last seven days" formatting but it highlights today as well.