Date formula

[tbird333]

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

 

[Bob Umlas, Excel MVP]

Select all the due dates, use Format/Conditional Formatting, change Cell
Value is to Formula Is, enter
=A2+30>TODAY() (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+90>TODAY(), click Format, assign a different color, OK your way out...

 

[tbird333]

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

 

[Gord Dibben]

Re-read Bob's reply.

Your answer is there.


Gord Dibben MS Excel MVP