L lisaella New Member Jun 8, 2010 #1 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.
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.
Hui Excel Ninja Staff member Jun 8, 2010 #2 Lisaella Select your range of cells goto Conditional Formatting Use a Formula to determine which cells to Format use the formula =D4<Today() where D4 is the first cell in your range (Change D4 to suit) Set your format Enjoy
Lisaella Select your range of cells goto Conditional Formatting Use a Formula to determine which cells to Format use the formula =D4<Today() where D4 is the first cell in your range (Change D4 to suit) Set your format Enjoy
K keymaster New Member Jun 8, 2010 #3 While Hui's suggestion may work, it can still highlight some cell's with todays date. So instead try =D4<TODAY() to highlight past dates. Also see: http://chandoo.org/wp/2010/01/05/conditional-formatting-dates
While Hui's suggestion may work, it can still highlight some cell's with todays date. So instead try =D4<TODAY() to highlight past dates. Also see: http://chandoo.org/wp/2010/01/05/conditional-formatting-dates