Thread: Date formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default Date formula

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