Highlight cells on 20 days from birthday

I have an excel spreadsheet with about 50 names. One of the columns on the spreadsheet is labeled, "Birthday." I am trying to figure out how I can program this spreadsheet to cause the cell to change it's background color so that when I glance at the spreadsheet I can tell whose birthday is 20 days out from the day that I am looking at the spreadsheet. In other words, today is May 11th. I would like to open up the spreadsheet today and have any birthday 20 days or less out from today have the cell highlighted so that I can easily pick out whose birthday is coming up. Then after the birthday date is over, have the cell go back to it's normal color.

Hi,
There is no need of programming. You can use conditional formatting. See attached file example.

Buran

That formula won't work if today is say, December 25, 2011. It will not highlight the Jan 1, 1990 birthday....

Try conditional formatting formula:

=IF((DATE(YEAR(TODAY()),MONTH(A2),DAY(A2)))<TODAY(),DATE(YEAR(TODAY())+1,MONTH(A2),DAY(A2)),(DATE(YEAR(TODAY()),MONTH(A2),DAY(A2))))<TODAY()+20

Look at the attached.

Alan

@NBVC - you are right, my mistake. thanks for this correction :-)