View Single Post
  #1   Report Post  
Kinghart Kinghart is offline
Junior Member
 
Posts: 21
Default conditional formating - Help

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