Formula help
 

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

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

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

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