Select the cell; use Format | Conditional Format
Formula Is: =A1-TODAY()<3 ... then Format as needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"pierre" wrote in message
...
i have in A1 the following date: 06/10/2008
i would like to say :
if i reach in a few days this date , turn it to red color

how to do that?????