Am sorry, It is not giving any error actually I missed closed bracket ")"
while copying the formula that's why it was giving problem.

But, Still am not able to get the desired output, as nothing gets
highlighted after giving the formula.

Shweta Srivastava

"David Biddulph" wrote:

You're more likely to get help if you tell the group *which* error you're
getting.
--
David Biddulph

"Shweta Srivastava77" wrote
in message ...
It is giving error..Please elaborate the formula to make me understand.

Shweta Srivastava

"Stefi" wrote:

Select column of dates of birth!
Formats/Conditional formatting, choose formula for 1.condition
Enter this formula in formula field:
=AND(TODAY()=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1) )-14,TODAY()<=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1)))
Select a color in the Pattern tag!
Press OK!

Regards,
Stefi



"Tendresse" ezt Ã*rta:

I have a coulmn for recording children's dates of birth. Is there a way
to
get the cells to change colour 2 weeks prior to when the birthday is
due? Or
any other way to remind the user of each date 2 weeks prior?
Many thanks