Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Between Worksheets
I have a workbook with two worksheets. The first worksheet has 9 columns of
data. As I am assigned new tasks I add rows to the first worksheet. The second worksheet is a calandar of employees.The tasks have assigned due dates which are input into column C of the first worksheet. The name of the employee tasked with said item is in column B. I would like the workbook take the due dates and the person associated with it and go to the second worksheet, find the due date for the task and the associated person and highlight it. Also when the item is closed or completed the first worksheet column D is changed from Open to Closed. When this happens I would like highlighting of the date on the calendar worksheet to go away. Workbook Worksheet#1 "Tasks" 9 columns of data A "ID Code" B "Person Assigned" C "Due Date" D "Status" (Open-means working on it Closed-means completed) The rest of the columns are project specific descriptors Worksheet#2 "Calendar" The calendar is broken into months and the months follow underneath the previous one. Each person has there own row. In each row Column A is there name. Following them is the day of the month 1,2,3,...,31 (or however many days there are) The values for 1,2,etc are acutally the entire date stored as MM/DD/YYYY, but only displaying DD So basically I want it to highlight the due date of the task from "Tasks" on "Calendar" when the Status is Open and to not highlight it when the status is closed. Sorry that was so long. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting across worksheets | Excel Worksheet Functions | |||
Conditional formatting between worksheets | Excel Discussion (Misc queries) | |||
Conditional formatting between worksheets | Excel Discussion (Misc queries) | |||
Conditional formatting/ comparing worksheets | Excel Discussion (Misc queries) | |||
Conditional formatting between worksheets? | Excel Worksheet Functions |