Hi Lowan

You can use conditional formatting to highlight the cells one week ago.

Select the cells, goto Formatting Conditional Formatting Condition 1:
"Formula is" =A1+DateValue("7/1/1900")<=Today()

Click Format and format as desired. OK

Hopes this helps.
....
Per

"Lowan Chan" skrev i meddelelsen
...
Hi,

for example:

column A
23/06/2009
30/06/2009
02/07/2009
05/07/2009

if today is 09/07/2009, in what way I can be reminded that A1, A2 & A3 are
the date that one week ago. For example, the text will change to Red
color,
or there is a pop-up window that can remind me?

Thanks.
--
Lowan