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?

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

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

Thank you so much. I think I was on the right path, I just couldn't figure

out which parts to change.

out which parts to change.

One last question, I think...what is format painter? I'm using Excel 2003.

I don't see that in any of my menus.

I don't see that in any of my menus.

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

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

Go on! Be brave! Type "format painter" into Excel help. [You don't have

to pay extra to use the facility.]

The same applies for many other questions. It's always worth trying Excel

help first. When you've done that, you can always come back and ask here if

there is something you don't understand in what help tells you.

to pay extra to use the facility.]

The same applies for many other questions. It's always worth trying Excel

help first. When you've done that, you can always come back and ask here if

there is something you don't understand in what help tells you.

1. My apostrophe and quotations are making weird a's and e's

3. Birthdays - ask for year separately & allow for no year known.

4. I need a formula to help me calculate years of vesting for 401

5. Need formula to figure compound interest of a deposit for a year

6. Need formula to figure out percentage of change for 5 years

7. New Field -- Date Field + 10 years formula needed.

8. Formula Help Needed to Spread Days Across Months/Years

9. I need a formula to help me calculate years of vesting for 401K.

10. Seniority Years Formula needed

11. Year-to-date year to date formula

12. formula to calculate current year less the year born

13. Formula for showing Previous Year - Current Year

14. Formula for year (leap year)

15. ANN: ALL Secrets of making Pocket PC screenshots - everything you will EVER need to know!

6 post • Page:**1** of **1**