| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell color date sensitive
Folks,
I am trying to build a tracking product for training events that are accomplished and those that are due. I want to have a cell that turns from Green Yellow Red, based on a timeframe that I pick. Example: John Doe completes yearly Egress training on 1-18-2008 that cell will remain Green until 3 months from his due date and then the cell will turn Yellow. At the date that Egress training is due again the cell will turn Red until the training is completed. I hope that I have not confused anyone your help in this will make my job easier to track upcoming and overdue training. -- RGM |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell color date sensitive
The feature you need is called Conditional Formatting. You can access it by
doing Format ConditionalFormatting and following the menus. You can invoke a base color to the cell, and 3 conditional ones. Try it, and post back if you have questions. Vaya con Dios, Chuck, CABGx3 "mcneilr" wrote: Folks, I am trying to build a tracking product for training events that are accomplished and those that are due. I want to have a cell that turns from Green Yellow Red, based on a timeframe that I pick. Example: John Doe completes yearly Egress training on 1-18-2008 that cell will remain Green until 3 months from his due date and then the cell will turn Yellow. At the date that Egress training is due again the cell will turn Red until the training is completed. I hope that I have not confused anyone your help in this will make my job easier to track upcoming and overdue training. -- RGM |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell color date sensitive
I am sorry CLR I am not fluent in Code. Can you give me an example of how
to write the string using todays date and have the cell Green. Maybe then I can go in and modify it for the rest of my tracking. -- RGM "CLR" wrote: The feature you need is called Conditional Formatting. You can access it by doing Format ConditionalFormatting and following the menus. You can invoke a base color to the cell, and 3 conditional ones. Try it, and post back if you have questions. Vaya con Dios, Chuck, CABGx3 "mcneilr" wrote: Folks, I am trying to build a tracking product for training events that are accomplished and those that are due. I want to have a cell that turns from Green Yellow Red, based on a timeframe that I pick. Example: John Doe completes yearly Egress training on 1-18-2008 that cell will remain Green until 3 months from his due date and then the cell will turn Yellow. At the date that Egress training is due again the cell will turn Red until the training is completed. I hope that I have not confused anyone your help in this will make my job easier to track upcoming and overdue training. -- RGM |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell color date sensitive
Format ConditionalFormatting FormulaIs: =$A1=TODAY() FormatButton
PatternsTab Pick a color OK OK Vaya con Dios, Chuck, CABGx3 "mcneilr" wrote: I am sorry CLR I am not fluent in Code. Can you give me an example of how to write the string using todays date and have the cell Green. Maybe then I can go in and modify it for the rest of my tracking. -- RGM "CLR" wrote: The feature you need is called Conditional Formatting. You can access it by doing Format ConditionalFormatting and following the menus. You can invoke a base color to the cell, and 3 conditional ones. Try it, and post back if you have questions. Vaya con Dios, Chuck, CABGx3 "mcneilr" wrote: Folks, I am trying to build a tracking product for training events that are accomplished and those that are due. I want to have a cell that turns from Green Yellow Red, based on a timeframe that I pick. Example: John Doe completes yearly Egress training on 1-18-2008 that cell will remain Green until 3 months from his due date and then the cell will turn Yellow. At the date that Egress training is due again the cell will turn Red until the training is completed. I hope that I have not confused anyone your help in this will make my job easier to track upcoming and overdue training. -- RGM |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell color date sensitive
CONDITION 1 =E4:E991=TODAY()
CONDITION 2 OK that worked, now for me to project out 9 months and have that date turn Yellow?????????????? CONDITION 3, Now if the training expires 12 months from todays date Thank You... RGM "CLR" wrote: Format ConditionalFormatting FormulaIs: =$A1=TODAY() FormatButton PatternsTab Pick a color OK OK Vaya con Dios, Chuck, CABGx3 "mcneilr" wrote: I am sorry CLR I am not fluent in Code. Can you give me an example of how to write the string using todays date and have the cell Green. Maybe then I can go in and modify it for the rest of my tracking. -- RGM "CLR" wrote: The feature you need is called Conditional Formatting. You can access it by doing Format ConditionalFormatting and following the menus. You can invoke a base color to the cell, and 3 conditional ones. Try it, and post back if you have questions. Vaya con Dios, Chuck, CABGx3 "mcneilr" wrote: Folks, I am trying to build a tracking product for training events that are accomplished and those that are due. I want to have a cell that turns from Green Yellow Red, based on a timeframe that I pick. Example: John Doe completes yearly Egress training on 1-18-2008 that cell will remain Green until 3 months from his due date and then the cell will turn Yellow. At the date that Egress training is due again the cell will turn Red until the training is completed. I hope that I have not confused anyone your help in this will make my job easier to track upcoming and overdue training. -- RGM |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell color date sensitive
I think maybe using =TODAY() will mess you up in the long run............
This should work better........... Use CellValueIs: equal to =$A$1 for the base date you wish to reference CellValueIs: equal to =$A$1+270 for 9 months later CellValueIs: equal to =$A$1+365 for one year later Presuming A1 is where a date is that you wish to reference........you can of course put it in any other cell.........just change A1 to that cell number. Vaya con Dios, Chuck, CABGx3 "mcneilr" wrote in message ... CONDITION 1 =E4:E991=TODAY() CONDITION 2 OK that worked, now for me to project out 9 months and have that date turn Yellow?????????????? CONDITION 3, Now if the training expires 12 months from todays date Thank You... RGM "CLR" wrote: Format ConditionalFormatting FormulaIs: =$A1=TODAY() FormatButton PatternsTab Pick a color OK OK Vaya con Dios, Chuck, CABGx3 "mcneilr" wrote: I am sorry "CLR" I am not fluent in Code. Can you give me an example of how to write the string using today's date and have the cell Green. Maybe then I can go in and modify it for the rest of my tracking. -- RGM "CLR" wrote: The feature you need is called Conditional Formatting. You can access it by doing Format ConditionalFormatting and following the menus. You can invoke a base color to the cell, and 3 conditional ones. Try it, and post back if you have questions. Vaya con Dios, Chuck, CABGx3 "mcneilr" wrote: Folks, I am trying to build a tracking product for training events that are accomplished and those that are due. I want to have a "cell" that turns from Green - Yellow - Red, based on a timeframe that I pick. Example: John Doe completes yearly Egress training on 1-18-2008 that cell will remain Green until 3 months from his due date and then the cell will turn Yellow. At the date that Egress training is due again the cell will turn Red until the training is completed. I hope that I have not confused anyone. your help in this will make my job easier to track upcoming and overdue training. -- RGM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date sensitive cell pattern color | Excel Worksheet Functions | |||
| How to set up a date sensitive notification? | Excel Discussion (Misc queries) | |||
| How to set up a date sensitive notification? | Excel Discussion (Misc queries) | |||
| how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
| Trying to make cell "date sensitive" to specific date | Excel Discussion (Misc queries) | |||
Hybrid Mode
