If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change colour once a certain time period passed
I record the date of when I send a letter. I send several hundred of these letters. Once 30 days passes, I need to send out a reminder to these people that receive the letters. I was thinking that perhaps the best way to do this would be to have the cells automatically change colour to indicate that 30 days has passed. But as only a basic formula user in excel, whats the simpliest way to do this? -- Dianne ------------------------------------------------------------------------ Dianne's Profile: http://www.excelforum.com/member.php...o&userid=30299 View this thread: http://www.excelforum.com/showthread...hreadid=499642 |
#2
|
|||
|
|||
Change colour once a certain time period passed
Use conditional formatting, select your cells then go to Format/Condtional
Formatting, then select cell value is less than or equal to and type: =TODAY()-30 choose your formatting...say red background and hit ok HTH JG "Dianne" wrote: I record the date of when I send a letter. I send several hundred of these letters. Once 30 days passes, I need to send out a reminder to these people that receive the letters. I was thinking that perhaps the best way to do this would be to have the cells automatically change colour to indicate that 30 days has passed. But as only a basic formula user in excel, whats the simpliest way to do this? -- Dianne ------------------------------------------------------------------------ Dianne's Profile: http://www.excelforum.com/member.php...o&userid=30299 View this thread: http://www.excelforum.com/showthread...hreadid=499642 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Time Zone suggestions for Outlook Calendar | Ben Knox | Calendar | 2 | October 20th, 2005 03:42 PM |
Totalling time over a several day period | stillcrazee | Using Forms | 1 | September 7th, 2005 11:25 AM |
Calendar Question | Josh | General Discussion | 7 | March 28th, 2005 11:19 PM |
Time change causes chaos | Tim Petlock | Calendar | 0 | March 15th, 2005 02:15 PM |
Change outlook calendar background color by day, or time period | maleck44 | Calendar | 1 | October 3rd, 2004 06:32 PM |