Re-read Bob's reply.

Your answer is there.


Gord Dibben MS Excel MVP

On Fri, 16 May 2008 11:59:00 -0700, tbird333
wrote:

I need to put in the date it was complete(say yesterday) and when it is
within 3 months of being due turn yellow, and with in 30 days turn red. so i
put in a completed date and when it is at 305 or 335 days form complete it
changes color

I used the formula given below and received a relative reference message
"Bob Umlas, Excel MVP" wrote:

Select all the due dates, use Format/Conditional Formatting, change Cell
Value is to Formula Is, enter
=A2+30TODAY() (assumes A2 is the active cell -- substitute as appropriate)
then click the Format button and assign one color, click OK, click Add,
change Cell Value is to Formula Is, enter
=A2+90TODAY(), click Format, assign a different color, OK your way out...

"tbird333" wrote:

I am making a spreadsheet for upcoming training and it due dates. i am
trying to set it up where when training is complete you enter the date and
time, and then when it comes withing 3 month of being due again it changes
color, and then at one month it changes again. I am having a hard time
finding the rule/formula to make this work