 |
 | 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 / Programming / March 2008Business Days
In need to be able to highlight a row if the date in that row is greater than 10 business days. I have already stored today as a variable called "today."  SignatureRegards, Michael Use the WORKDAY function. You could set up Conditional Formatting using: "=WORKDAY(today,10)>$A$1" Give that a try. Matthew Pfluger > In need to be able to highlight a row if the date in that row is greater than > 10 business days. I have already stored today as a variable called "today." Worked.. Thanks So much........... SignatureRegards, Michael > Use the WORKDAY function. You could set up Conditional Formatting using: > "=WORKDAY(today,10)>$A$1" [quoted text clipped - 4 lines] > > In need to be able to highlight a row if the date in that row is greater than > > 10 business days. I have already stored today as a variable called "today." >In need to be able to highlight a row if the date in that row is greater than >10 business days. I have already stored today as a variable called "today." Go to Tools > Addins and make sure "Analysis Toolpak - VBA" is checked. In the VBE, go to Tools > References and set a reference to atpvbaen.xls. Then you can call the NETWORKDAYS function directly Sub HighlightDays() If Abs(networkdays(Sheet1.Range("A4").Value, Date)) > 10 Then Sheet1.Range("A4").EntireRow.Interior.Color = vbYellow End If End Sub SignatureDick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com Worked!!!! Thanks so much......... SignatureRegards, Michael > >In need to be able to highlight a row if the date in that row is greater than > >10 business days. I have already stored today as a variable called "today." [quoted text clipped - 10 lines] > > End Sub |
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.