Need to know formula to make expire in a year.

[tlbailey79]

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?

 

[Mike H]

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]

Thank you so much. I think I was on the right path, I just couldn't figure
out which parts to change.

 

[tlbailey79]

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]

Sorry i should have explained.

If the formatting toolbar isn't visible then
View|Toolbars|Formatting

select the cell where you entered the CF then look on the formatting toolbar
and you'll see something that looks like a paintbrush
Click it

Click into any other cells you want the formatting painting in to and you
can drag by holding the left mouse button for multiple cells. the references
will change automatically.

Mike