Hi
Can Anyone help me with this
I want excel to highlight the far most date from today in red, and next far most in yellow in a following table like this...

XXXX
01 Nov 2008
14 Nov 2008
12 Oct 2008
06 Nov 2008
31 Oct 2008

Suppose your dates are in A1:A5

For A1 you could use conditional format with following formula as criteria1:
=A1=LARGE($A$1:$A$5,1)
Choose red as cell color.

For criteria2 you can use
=A1=LARGE($A$1:$A$5,2)
Choose yellow as cell color.

Now use the format painter and copy the format of A1 down to A5.

Make sure that the dates are "real" dates recognizable by Excel, not just
text.

Joerg



"Kinghart" wrote in message
...

Hi
Can Anyone help me with this
I want excel to highlight the far most date from today in red, and next
far most in yellow in a following table like this...

XXXX
01 Nov 2008
14 Nov 2008
12 Oct 2008
06 Nov 2008
31 Oct 2008




--
Kinghart

Thanks Buddy.... Ur formula was very useful though it didn't get what I wanted.... but I modified it (Large to Small) and got what I wanted. (i.e. the far most dates from today) :-)

can u help me with this..... I'm attaching it

Your're welcome. Thanks for the feedback. Still curious though how you found
the farthest date with the SMALL function...

"Kinghart" wrote in message
...

Joerg Mochikun;755534 Wrote:
Suppose your dates are in A1:A5

For A1 you could use conditional format with following formula as
criteria1:
=A1=LARGE($A$1:$A$5,1)
Choose red as cell color.

For criteria2 you can use
=A1=LARGE($A$1:$A$5,2)
Choose yellow as cell color.

Now use the format painter and copy the format of A1 down to A5.

Make sure that the dates are "real" dates recognizable by Excel, not
just
text.

Joerg



"Kinghart" wrote in message
...-

Hi
Can Anyone help me with this
I want excel to highlight the far most date from today in red, and
next
far most in yellow in a following table like this...

XXXX
01 Nov 2008
14 Nov 2008
12 Oct 2008
06 Nov 2008
31 Oct 2008




--
Kinghart -

Thanks Buddy.... Ur formula was very useful though it didn't get what I
wanted.... but I modified it (Large to Small) and got what I wanted.
(i.e. the far most dates from today) :-)


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Kinghart