in a single cell:

Format, Conditional Formatting

"Cell Value is", "Less than"

Enter 1/1/2005 in the third box (better yet, for a dynamic highlight, give
it a fixed cell reference [eg '=$A$1' then enter 1/1/2005 at A1).

Change your font and background to suit.

If you have the format painter showing, use it to paint the format on all
cells you want showing this way. Otherwise use Copy, Paste Special, Formats.




HTH
Steve



"Soth" wrote in message
...
Hello,

date: 01/01/2005

If date is expired beyon 01/01/2005 , what I'd like to see is that, it
changes to color red.

Is is possible to create this formular?

Thanks,
Sothea