Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-27-2014, 04:16 PM
copwriter copwriter is offline Conditional Formatting - past due dates Windows 7 64bit Conditional Formatting - past due dates Office 2010 64bit
Novice
 
Join Date: Jun 2014
Posts: 4
copwriter is on a distinguished road
Default

This formula entered into Conditional Formatting should do it:

=TODAY()>B2

The formula tests whether the current date is past the date in Cell B2. If the statement is true, it applies the formatting. If false, nothing happens. Since B2 is already seven days after the date in A2, any date past that will result in the statement being true.

I highlighted the cell with a red fill and white font. You can, of course, use any formatting you choose.

Once you have this Conditional Formatting formula entered into B2, you can use the Format Painter to copy the conditional formatting to other cells.

I hope this helps.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting with Dates namedujour Excel 1 02-21-2013 03:42 AM
Conditional formatting zanat0s Excel 4 01-20-2012 03:30 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Frogggg Excel 1 10-25-2011 08:44 PM
Conditional Formatting - past due dates Conditional formatting with AND, OR Lucky Excel 2 10-03-2011 11:41 PM
Conditional Formatting - past due dates help with conditional formatting Snvlsfoal Excel 3 07-03-2011 11:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft