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?

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
>
>