One last question, I think...what is format painter? I'm using Excel 2003.
I don't see that in any of my menus.

"Mike H" wrote:

Try


Format|Conditional format
Formula is
=AND(A1<"",A1<TODAY()-365)
Pick a colour
OK

use format painter to paint this into the other cells

Mike

"tlbailey79" wrote:

I was asked if I could create a spreadsheet where we could keep track of
vendors and when they took the safety training for our company. The training
is only good for one year. So I would have a date field. Then I was asked
if I could make it so a year from now the text would change color or
something, to let them know that the safety training had expired. Is there
some sort of formula or function that I could use for this?