Use conditional formattingCell valeLess than and enter
=DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))

--
Ian
--
"renate" wrote in message
...
In our company we have safety harnesses and they need to be recertified
every
year. I Would like to put the date in and then for it to show up as
expired
in a year with a different colour. There must be a way to do this with a
formula or something?

Thanks