Formula is =(ABS($C1-TODAY())<=365) for the green
Formula is =(ABS($C1-TODAY())365) for the red
But of course it doesn't deal with the subtleties of leap years.
--
David Biddulph

"Jason Bartup" <Jason wrote in message
...
I wish for certain cell to be say green if date entered is within one year
of
todays date. Then change to red if date is over one year of todays date.
I
know this is possible but cant get the right formular