conditional formating - Help

[Kinghart]

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

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

 

[Joerg Mochikun]

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]

Suppose your dates are in A1:A5

For A1 you could use conditional format with following formula a
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, no
just
text.

Joerg

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

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

 

[Joerg Mochikun]

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