Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-27-2014, 08:28 AM
namedujour
Guest
 
Posts: n/a
Default Conditional Formatting - past due dates

I have a formula in B2 to display the date that appears in A2, plus 7 days. I typed "7" into Sheet 2, C2, and refer to that cell in the formula.

Now I would like to highlight B2, if today's date is more than 7 days past the date in A2. In other words,



A2 = 6/1/14
B2 = 6/8/14 with formula: =IF(A2="","",(SUM(A2+Sheet2!$C$2)))
Today's date is 6/27/14, so B2 needs to be highlighted in red.

Is there any way to do that?

Thanks!
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 10: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