See http://xldynamic.com/source/xld.CF.html#due fir an example

--
__________________________________
HTH

Bob

"flasherr" wrote in message
...
Hi
I would like to keep training records using excel

what I need is have a cell change color and display training required if
the Colum 1 date trained goes past 12 months

any help would be great

Tony