Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to know formula to make expire in a year.
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to know formula to make expire in a year.
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to know formula to make expire in a year.
Thank you so much. I think I was on the right path, I just couldn't figure
out which parts to change. "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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to know formula to make expire in a year.
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to know formula to make expire in a year.
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 "tlbailey79" wrote: 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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to know formula to make expire in a year.
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. -- David Biddulph "tlbailey79" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Expire count down | Excel Worksheet Functions | |||
need formula 4 %change on both neg and pos movemnt year to year co | Excel Discussion (Misc queries) | |||
Make Worksheets Given a Certain YEAR | Excel Discussion (Misc queries) | |||
how do i calculate what i make in a year into an hour? | Excel Worksheet Functions | |||
How would I make a calendar template in Excel for the year 2006?? | Excel Worksheet Functions |