• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

conditional formatting past dates

lisaella

New Member
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.
 
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
 
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
 
Back
Top