 |
 | 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 / May 2008conditional formating on dates
Hello, I have to track expiry dates in a datasheet. Actually, I'd like the expiry date field to change color 30 days prior to the expiry date written in the field. Let's say the expiry date is oct 24 2008, I want the field to change color on sept 25 2008. The date format chosen is 24-oct-08, does it matter? Thanks!  SignatureMargot try this =(G1-TODAY()<30) > Hello, > [quoted text clipped - 4 lines] > > Thanks! And G1 stands for? SignatureMargot > try this > [quoted text clipped - 8 lines] > > > > Thanks! G1 is the cell with the conditional formating. > And G1 stands for? > [quoted text clipped - 10 lines] > > > > > > Thanks! Hi Margot, Expiry date in B1. In C1: =B1-30 Select your date(s) Format>Conditional Formatting Select Cell value is, next box select greater than, next box click C1, so you get =$C$1, click Format, select a color and click OK and once more. SignatureKind regards, Niek Otten Microsoft MVP - Excel | Hello, | [quoted text clipped - 4 lines] | | Thanks! Hi, If you have the dates in column A starting with row1, then you can use following logic in conditional formatting:- =IF(A1-NOW()<=30,"True","False") SignatureDilip Kumar Pandey MBA, BCA, B.Com(Hons.) dilipandey@yahoo.com dilipandey@gmail.com New Delhi, India > Hello, > [quoted text clipped - 4 lines] > > Thanks! ... or just =A1-NOW()<=30 -- David Biddulph > Hi, > If you have the dates in column A starting with row1, then you can use [quoted text clipped - 13 lines] >> >> Thanks! |
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.