HI Pete
thanks thats just what i was hoping to do, although the colour
change reverts to default ( black ) when i add another date to the column .
any way to make the cells stay changed when i add another date

cheers

rslc


"Pete_UK" wrote in message
...
Suppose your dates are in column A from A1 onwards. Highlight the
cells from A2 onwards (i.e. omitting the first date) as far as you
think you will need, and use this formula for the first conditional
format rule:

=AND(A2=LOOKUP(10E10,A:A),A2A1+5)

and format that as red. Use this formula for your second condition:

=AND(A2=LOOKUP(10E10,A:A),A2A1,A2<=A1+5)

and format that as green. OK your way out of the CF dialogue box.

Hope this helps.

Pete

On Jan 25, 8:32 am, "rslc" wrote:
Hi
i have a list of dates ie 01/02/09
03/02/09
07/02/09

what i would like to happen is when the last date exceeds the
previous date by more than 5 days, highlight it in red and if it less
than 5
days older highlight it green. i have tried in cell formulas and
conditional
formatting but so far no luck Appreciate any help


thanks

rslc