1. Select the cell/Range (column A)
2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=AND(A1<"",TODAY()-A1=7)

4. Click Format ButtonPattern and select your color (say Red)
5. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Lowan Chan" wrote:

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