| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get a cells information to a calendar
I have a workbook with a spreadsheet and would like to add a calendar in the
workbook. Is there anyway from the example below I could get the date from D2 to showup on a calendar in some color with the information from A2 A B C D 1 Location Date Tested Days Until Due Date Due Date 2 Kansas City 9/15/08 20 10/15/08 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a cells information to a calendar
Conditional Formating ?
"wdh" ... I have a workbook with a spreadsheet and would like to add a calendar in the workbook. Is there anyway from the example below I could get the date from D2 to showup on a calendar in some color with the information from A2 A B C D 1 Location Date Tested Days Until Due Date Due Date 2 Kansas City 9/15/08 20 10/15/08 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a cells information to a calendar
I have a file that will do this - send me an email to:
pashurst <at auditel.net and I'll send it to you. Pete On Sep 26, 1:01*am, wdh wrote: I have a workbook with a spreadsheet and would like to add a calendar in the workbook. Is there anyway from the example below I could get the date from D2 to showup on a calendar in some color with the information from A2 * * * * A * * * * * * * * * * * * * *B * * * * * * * * * * * *C * * * * * * * * * * * *D 1 *Location * * * * * * Date Tested * * *Days Until Due Date * * Due Date 2 Kansas City * * * * * * 9/15/08 * * * * * * * * * *20 * * * * * * * * * 10/15/08 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I get a cells information to a calendar
Worked great Pete
"Pete_UK" wrote: I have a file that will do this - send me an email to: pashurst <at auditel.net and I'll send it to you. Pete On Sep 26, 1:01 am, wdh wrote: I have a workbook with a spreadsheet and would like to add a calendar in the workbook. Is there anyway from the example below I could get the date from D2 to showup on a calendar in some color with the information from A2 A B C D 1 Location Date Tested Days Until Due Date Due Date 2 Kansas City 9/15/08 20 10/15/08 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Send date information from two cells to Outlook Calendar | Excel Discussion (Misc queries) | |||
| Can I link dates within 2 different cells to a calendar? | Excel Discussion (Misc queries) | |||
| 2006 calendar on separate worksheets with several cells within a d | Excel Discussion (Misc queries) | |||
| How do place a column of date/time information into a calendar for | Excel Discussion (Misc queries) | |||
| Calendar based on varying information/ Pivot Table General | Charts and Charting in Excel | |||
Linear Mode
