View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default 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