 |
 | 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 / Worksheet Functions / June 2006Use of conditional formatting to remind of forthcoming birthdays
Hi, I have a list of birthdays in my Excel spreadsheet. I would like the cell containing the date to change colour when the birthday is approaching (14 days before the date). To do this I have come up with the following to enter in the Formula Is box.. =IF(AND(TODAY()-DATE(YEAR(TODAY()),MONTH(A5),DAY(A5))<15,TODAY()-DATE(YEAR(TODAY()),MONTH(A5),DAY(A5))>0)) However, Excel suggests there is an error - any idea what is wrong? Thanks!! Andy  SignatureAndreas L. Nel post news:EC272240-B9B0-4454-9227-11305FBA9063@microsoft.com *AndyL82* ha scritto: > Hi, > I have a list of birthdays in my Excel spreadsheet. I would like the [quoted text clipped - 5 lines] > Thanks!! > Andy Hi Andy, put this formula in the Formula Is box: =AND(TODAY()-DATE(YEAR(TODAY()),MONTH(A15),DAY(A15))<15) SignatureHope I helped you. I'm not sure of names of menues, option and commands, because translating from the Italian version of Excel... Ciao Franz Verga from Italy Nel post news:uf4cFhMlGHA.1640@TK2MSFTNGP02.phx.gbl *Franz Verga* ha scritto: > Nel post news:EC272240-B9B0-4454-9227-11305FBA9063@microsoft.com > *AndyL82* ha scritto: [quoted text clipped - 13 lines] > > =AND(TODAY()-DATE(YEAR(TODAY()),MONTH(A15),DAY(A15))<15) The correct formula is: =AND(TODAY()-DATE(YEAR(TODAY()),MONTH(A15),DAY(A15))<15,TODAY()-DATE(YEAR(TODAY()),MONTH(A15),DAY(A15))>0) Signature(I'm not sure of names of menues, option and commands, because translating from the Italian version of Excel...) Hope I helped you. Ciao Franz Verga from Italy Excel is telling you that you've entered an IF function, but haven't completed it (ie, no true or false result). When using conditional formatting, don't use IF. Start the formula with AND. SignatureRegards, Fred > Hi, > I have a list of birthdays in my Excel spreadsheet. I would like the cell [quoted text clipped - 5 lines] > Thanks!! > Andy |
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
|
©2009 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.