How to Highlight All Cells Containing Future Date in Excel 2007
October 15, 2012 8:05 AM   Subscribe

In Excel 2007, is there a way to highlight all cells within a certain range (in my case, five adjacent columns) that contain dates in the future?

I've been Googling to no avail. This seems like a pretty straighforward thing, so I'm suprised I'm having such a hard time with it.

I'm not 100% sure what other info you might need, but let me know and I'll be happy to provide it.

Any help is much appreciated! Thanks in advance.
posted by smirkyfodder to Computers & Internet (2 answers total) 1 user marked this as a favorite
 
Best answer: Use conditional formatting, and set the condition to greater than =today().
posted by Perplexity at 8:07 AM on October 15, 2012


Response by poster: Yay! Thanks!
posted by smirkyfodder at 8:10 AM on October 15, 2012


« Older Living with Psychopaths. Need Help.   |   I knew quitting would be hard, but... Newer »
This thread is closed to new comments.


Tags

Share