| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to apply funcation
I have an excel sheet for vacation plan It has last working day, last vacation day, and the month from Jan to Dec, each month divided into 4 parts (weeks). I need to format the specific week automatically when the user input the date in above cells . The specific week (last working day) through another week (last vacation day)(like in MS project) Your help is highly appreciated thx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to apply funcation
use conditional formatting - if you email me I can show you this, and
also let you have my absence planning worksheet which might help you. ghost wrote: I have an excel sheet for vacation plan It has last working day, last vacation day, and the month from Jan to Dec, each month divided into 4 parts (weeks). I need to format the specific week automatically when the user input the date in above cells . The specific week (last working day) through another week (last vacation day)(like in MS project) Your help is highly appreciated thx |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to apply funcation
i have emailed you
" wrote: use conditional formatting - if you email me I can show you this, and also let you have my absence planning worksheet which might help you. ghost wrote: I have an excel sheet for vacation plan It has last working day, last vacation day, and the month from Jan to Dec, each month divided into 4 parts (weeks). I need to format the specific week automatically when the user input the date in above cells . The specific week (last working day) through another week (last vacation day)(like in MS project) Your help is highly appreciated thx |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to apply funcation
sorry aidan it is not what i need
thx "ghost" wrote: I have an excel sheet for vacation plan It has last working day, last vacation day, and the month from Jan to Dec, each month divided into 4 parts (weeks). I need to format the specific week automatically when the user input the date in above cells . The specific week (last working day) through another week (last vacation day)(like in MS project) Your help is highly appreciated thx |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to apply funcation
Did you get the Gantt chart file I mailed you as this looked EXACTLY
what you needed ghost wrote: sorry aidan it is not what i need thx "ghost" wrote: I have an excel sheet for vacation plan It has last working day, last vacation day, and the month from Jan to Dec, each month divided into 4 parts (weeks). I need to format the specific week automatically when the user input the date in above cells . The specific week (last working day) through another week (last vacation day)(like in MS project) Your help is highly appreciated thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I apply formula to entire column | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| How to apply rounding across a range of cells with other formulae | Excel Worksheet Functions | |||
| How to apply the same background to many sheets simultaneously. | Excel Worksheet Functions | |||
| make custom header and footer in excel apply to all worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
