 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Date formula
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 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... > 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 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 > Select all the due dates, use Format/Conditional Formatting, change Cell > Value is to Formula Is, enter [quoted text clipped - 8 lines] > > color, and then at one month it changes again. I am having a hard time > > finding the rule/formula to make this work Re-read Bob's reply. Your answer is there. Gord Dibben MS Excel MVP >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 [quoted text clipped - 15 lines] >> > color, and then at one month it changes again. I am having a hard time >> > finding the rule/formula to make this work |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.