guesse mine is not exactly what you asked, but an idea if flipping purposes /
values.. thanks


"MrDave" wrote:

If you have NOW() / Date-Time in B5, can use external cell A7 to have: 15
=MONTH(B5)+$A$7





"Lou825" wrote:

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.