Well, you did say that you wanted the last date to be formatted
according to the previous one. Perhaps you did not highlight
sufficient cells when you set up the CF to cover the addition of newer
cells - in that case use the Format Painter icon to extend the CF
further down the column. If you mean that you want all dates to have
the appropriate format applied to them (not just the last one), then
you can change the formulae to:

=A2A1+5

and format that as red, and for your second condition:

=AND(A2A1,A2<=A1+5)

Note that these expect A2 to be the active cell in a highlighted
range.

Hope this helps.

Pete

On Jan 26, 3:35*am, "rslc" wrote:
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