| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autofill colour based on date entry
I have a spreadsheet to record when monthly duty reports are received by each
employee and reviewed by mgmt. Column A1:A200 Employee Name Column B1:B200 Date Received in April Column C1:C200 Date Reviewed in April Column D1:D200 Date Received in May Column E1:E200 Date Reviewed in May etc Is there a formula I could use to fill the cell in grey when a report is not received when a report is received late in blue and when a report is received on time in pink? Reports received the 5th business day of the following month of the report (i.e. april report due the 5th business day in may) are considered late and reports reviewed after the 10th business day are late. Any suggestions without using code? Thanks!! :) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofill colour based on date entry
you would use the conditional formatting feature, along with the networkdays
formula, which is in the analysis toolpac add-in (if you don't have it, tools/add-ins and check it) "Tacrier" wrote: I have a spreadsheet to record when monthly duty reports are received by each employee and reviewed by mgmt. Column A1:A200 Employee Name Column B1:B200 Date Received in April Column C1:C200 Date Reviewed in April Column D1:D200 Date Received in May Column E1:E200 Date Reviewed in May etc Is there a formula I could use to fill the cell in grey when a report is not received when a report is received late in blue and when a report is received on time in pink? Reports received the 5th business day of the following month of the report (i.e. april report due the 5th business day in may) are considered late and reports reviewed after the 10th business day are late. Any suggestions without using code? Thanks!! :) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofill colour based on date entry
Unfortunately I am using Excel 2000 and in the process of getting my tech
guys to buy the 2007 office suite for my department. Any other suggestions? "dlw" wrote: you would use the conditional formatting feature, along with the networkdays formula, which is in the analysis toolpac add-in (if you don't have it, tools/add-ins and check it) "Tacrier" wrote: I have a spreadsheet to record when monthly duty reports are received by each employee and reviewed by mgmt. Column A1:A200 Employee Name Column B1:B200 Date Received in April Column C1:C200 Date Reviewed in April Column D1:D200 Date Received in May Column E1:E200 Date Reviewed in May etc Is there a formula I could use to fill the cell in grey when a report is not received when a report is received late in blue and when a report is received on time in pink? Reports received the 5th business day of the following month of the report (i.e. april report due the 5th business day in may) are considered late and reports reviewed after the 10th business day are late. Any suggestions without using code? Thanks!! :) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofill colour based on date entry
I have excel 2000, and it has the analysis toolpac. Maybe I downloaded it?
Check the MS web site. "Tacrier" wrote: Unfortunately I am using Excel 2000 and in the process of getting my tech guys to buy the 2007 office suite for my department. Any other suggestions? "dlw" wrote: you would use the conditional formatting feature, along with the networkdays formula, which is in the analysis toolpac add-in (if you don't have it, tools/add-ins and check it) "Tacrier" wrote: I have a spreadsheet to record when monthly duty reports are received by each employee and reviewed by mgmt. Column A1:A200 Employee Name Column B1:B200 Date Received in April Column C1:C200 Date Reviewed in April Column D1:D200 Date Received in May Column E1:E200 Date Reviewed in May etc Is there a formula I could use to fill the cell in grey when a report is not received when a report is received late in blue and when a report is received on time in pink? Reports received the 5th business day of the following month of the report (i.e. april report due the 5th business day in may) are considered late and reports reviewed after the 10th business day are late. Any suggestions without using code? Thanks!! :) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofill colour based on date entry
The ATP cannot be downloaded.
It is installed upon a "typical" installation in versions earlier than 2007. Activate through ToolsAdd-insATP Gord Dibben MS Excel MVP On Fri, 5 Dec 2008 07:53:00 -0800, dlw wrote: I have excel 2000, and it has the analysis toolpac. Maybe I downloaded it? Check the MS web site. "Tacrier" wrote: Unfortunately I am using Excel 2000 and in the process of getting my tech guys to buy the 2007 office suite for my department. Any other suggestions? "dlw" wrote: you would use the conditional formatting feature, along with the networkdays formula, which is in the analysis toolpac add-in (if you don't have it, tools/add-ins and check it) "Tacrier" wrote: I have a spreadsheet to record when monthly duty reports are received by each employee and reviewed by mgmt. Column A1:A200 Employee Name Column B1:B200 Date Received in April Column C1:C200 Date Reviewed in April Column D1:D200 Date Received in May Column E1:E200 Date Reviewed in May etc Is there a formula I could use to fill the cell in grey when a report is not received when a report is received late in blue and when a report is received on time in pink? Reports received the 5th business day of the following month of the report (i.e. april report due the 5th business day in may) are considered late and reports reviewed after the 10th business day are late. Any suggestions without using code? Thanks!! :) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autofill colour based on date entry
I tried to activate it through the toolsadd-insATP and a message appears
indicating a CD-ROM needs to be inserted. Still no luck. :( "Gord Dibben" wrote: The ATP cannot be downloaded. It is installed upon a "typical" installation in versions earlier than 2007. Activate through ToolsAdd-insATP Gord Dibben MS Excel MVP On Fri, 5 Dec 2008 07:53:00 -0800, dlw wrote: I have excel 2000, and it has the analysis toolpac. Maybe I downloaded it? Check the MS web site. "Tacrier" wrote: Unfortunately I am using Excel 2000 and in the process of getting my tech guys to buy the 2007 office suite for my department. Any other suggestions? "dlw" wrote: you would use the conditional formatting feature, along with the networkdays formula, which is in the analysis toolpac add-in (if you don't have it, tools/add-ins and check it) "Tacrier" wrote: I have a spreadsheet to record when monthly duty reports are received by each employee and reviewed by mgmt. Column A1:A200 Employee Name Column B1:B200 Date Received in April Column C1:C200 Date Reviewed in April Column D1:D200 Date Received in May Column E1:E200 Date Reviewed in May etc Is there a formula I could use to fill the cell in grey when a report is not received when a report is received late in blue and when a report is received on time in pink? Reports received the 5th business day of the following month of the report (i.e. april report due the 5th business day in may) are considered late and reports reviewed after the 10th business day are late. Any suggestions without using code? Thanks!! :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automating to autofill column B based on column A entry | Excel Discussion (Misc queries) | |||
| Autofill cell based on todays date | Excel Worksheet Functions | |||
| how do i autofill a cell a certain colour based on it's value? | Excel Worksheet Functions | |||
| Default colour in cell based on specific entry | Excel Worksheet Functions | |||
| Autofill date based on date in another cell | Excel Worksheet Functions | |||
Hybrid Mode
