| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bithday conditional
If you have birthdates in date format in column C, beginning with row 2,
select range, and Format - Conditional Formatting Change Cell Value Is: to Formula Is: and enter (copy and paste) this formula: =AND(DATE(YEAR(TODAY()),MONTH(C2),DAY(C2))=TODAY( ),DATE(YEAR(TODAY()),MONTH(C2),DAY(C2))<=TODAY()+1 0) Format as desired. Adjust ranges as necessary. Conditional formatting will begin 10 days before birthday and remain through birthday. DATE(YEAR(TODAY()),MONTH(C2),DAY(C2)) is converting the birthday in C2 to the same month and day of this year so that we can make a comparison to todays date... "Trippin" wrote: Im trying to get excel to highlight a birthday 10 days before it arrives i have dates and ages. i greatful for your help thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
| Conditional Value | Excel Discussion (Misc queries) | |||
| Conditional sum | Excel Worksheet Functions | |||
Hybrid Mode
