Change colour once a certain time period passed

[Dianne]

I record the date of when I send a letter. I send several hundred o
these letters. Once 30 days passes, I need to send out a reminder t
these people that receive the letters. I was thinking that perhaps th
best way to do this would be to have the cells automatically chang
colour to indicate that 30 days has passed. But as only a basi
formula user in excel, whats the simpliest way to do this

 

[pinmaster]

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