Formula help

[Soth]

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

 

[Steve]

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

 

[Gord Dibben]

Soth

Format>Conditional Formatting>Formula is:

=A1>DATEVALUE("01/01/2005")

Pick a red color from the Format>Patterns and OK your way out.


Gord Dibben Excel MVP

 

[Steve]

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