Bithday conditional
 

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

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