I Have a spredsheet with the birth dates of several people. I want
these dates to change color when they are 30 days away. I can do this
now with the [cell value is between =today() and =today()+30]
conditional formatting formula but I have to input the current year for
the birth day, I was wondering is there any way to get the same result
and input the actual year of the birth day. Ex. If the birth day is on
1 Jan 1984, I want the cell to change color on 2 Dec of every year and
the change back on 2 Jan.


--
pknivens
------------------------------------------------------------------------
pknivens's Profile: http://www.excelforum.com/member.php...o&userid=27675
View this thread: http://www.excelforum.com/showthread...hreadid=471898