Use conditional formatting.
--
David Biddulph

"bmcaf12345" wrote in message
...
I keep a log of dates that people receive financial assistance which is in
effect for 365 days. After 365 days they must renew their application.
Currently, I manually look for dates that are 365 days old and change the
text to red. I would like to find a formula that would do this for me.