Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing text/color after a time period?
I hope some of the brilliant Excel people here can help me out. What I am looking to do, is enter a date in a certain cell (if it helps conceptualize, the date that I ship something to someone). Is it possible to have that cell with the "ship date" in it, either change colors, or change the font size, or something, after 30 days have gone by? My reasoning is that the product I ship out, has to be back to me in 30 days, or a penalty will incur to the other party. I just want these fields that have exceeded the 30 day mark, to stick out, so I can easily identify them. Thanks for any help in advance! Rich -- metalsped ------------------------------------------------------------------------ metalsped's Profile: http://www.excelforum.com/member.php...o&userid=22824 View this thread: http://www.excelforum.com/showthread...hreadid=387488 |
#2
|
|||
|
|||
Try this:
http://www.officearticles.com/excel/...ft_ excel.htm ******************* ~Anne Troy www.OfficeArticles.com "metalsped" wrote in message ... I hope some of the brilliant Excel people here can help me out. What I am looking to do, is enter a date in a certain cell (if it helps conceptualize, the date that I ship something to someone). Is it possible to have that cell with the "ship date" in it, either change colors, or change the font size, or something, after 30 days have gone by? My reasoning is that the product I ship out, has to be back to me in 30 days, or a penalty will incur to the other party. I just want these fields that have exceeded the 30 day mark, to stick out, so I can easily identify them. Thanks for any help in advance! Rich -- metalsped ------------------------------------------------------------------------ metalsped's Profile: http://www.excelforum.com/member.php...o&userid=22824 View this thread: http://www.excelforum.com/showthread...hreadid=387488 |
#3
|
|||
|
|||
Awesome! Once again, someone comes through for me. Thanks a lot Anne! -- metalsped ------------------------------------------------------------------------ metalsped's Profile: http://www.excelforum.com/member.php...o&userid=22824 View this thread: http://www.excelforum.com/showthread...hreadid=387488 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rolling time period | Excel Worksheet Functions | |||
assign value for period of time | Excel Discussion (Misc queries) | |||
Time calculation for a givenn period | Excel Discussion (Misc queries) | |||
unmet challenge | Excel Worksheet Functions | |||
I really need help! Changing work period start dates | Excel Worksheet Functions |