=IF(AND(B1--LEFT(A1,10),B1<--RIGHT(A1,10)),"Within range","Not within
range")
and use Format/ Conditional formatting to colour the cell depending on the
content.
Can change and < to = and <= if the boundary values are to be regarded as
within the range.
--
David Biddulph

"Cathy" wrote in message
...
Hello

I am trying to change the colour and display of a cell dependant on if a
date is within a range. If the range is 24/12/2007:30/12/2007 in A1 and
the
date displayed is 26/12/2007 in B1, how do i get it to state in C1 that
the
date was within the range, green or not red.

thanks