Gord
I didn't find the need for datevalue, Excel recognised and changed 1/1/2005
into a dateserial. Does autoformattng handle it differently in different
versions?

Steve


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Soth

FormatConditional FormattingFormula is:

=A1DATEVALUE("01/01/2005")

Pick a red color from the FormatPatterns and OK your way out.


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 13:17:07 -0800, "Soth"

wrote:

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