put a date in d1 and then create the conditional formatting formula and
criteria and see if it does what you want.

=(today())DATE(YEAR(D1),MONTH(D1) +15,DAY(D1))

--

Gary Keramidas
Excel 2003


"Lou825" wrote in message
...
I have Excel 2003 and I am having a problem with conditional formatting. I
have a sheet that I put dates in cells and need the cell to change color
when
its 15 months from todays date.