| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use 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 -- Andreas L. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use of conditional formatting to remind of forthcoming birthdays
Nel post
*AndyL82* ha scritto: 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 Hi Andy, put this formula in the Formula Is box: =AND(TODAY()-DATE(YEAR(TODAY()),MONTH(A15),DAY(A15))<15) -- Hope 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use of conditional formatting to remind of forthcoming birthdays
Nel post
*Franz Verga* ha scritto: Nel post *AndyL82* ha scritto: 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 Hi Andy, put this formula in the Formula Is box: =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) -- (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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use of conditional formatting to remind of forthcoming birthdays
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. -- Regards, Fred "AndyL82" wrote in message ... 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 -- Andreas L. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
| Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
