Any chance of someone keying in a date prior to today's date, e.g. yesterday's date? If yes, do you want it green, red or something else?

Epinn

"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