 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / April 2008Conditional Format - Date + 7
I have a spreadsheet with a start date in column F starting at row 3. Column M needs to be highlighted a different colour if the value in F3 goes over 7 days. If there is already a date in column M, then this should be ignored. However, if the date in column M goes 7 days or more itself, then this also needs to be highlighted. Is there a way of using conditional formatting to achieve the above? Regards, JDB Hi JDB, It's a bit confusing but try a CF in column M with Formula is: =AND(NOT(ISBLANK(M3)),OR(TODAY()>F3+7,TODAY()>M3+7)) If that doesn't work then you need to give better details of when cols F and M are and aren't populated etc. and also more info all round. HTH Martin >I have a spreadsheet with a start date in column F starting at row 3. >Column [quoted text clipped - 9 lines] > > JDB I'm not sure what is happening here. The formula is showing in my immediate window with a semi-colon in the middle of it, but not in my posting window. ?????? Whatever, if a semi-colon is showing change it to a comma. Regards Martin > Hi JDB, > [quoted text clipped - 24 lines] >> >> JDB |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.