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

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