Originally Posted by 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" 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