Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting with 2 variables (or 3?)
I have a problem that I've been trying to solve the last 2 days without results.
I need to add the period in which an employee will be working in a graph ( see Calendar Tab). In the sheet 1, every employees will have a task assigned and a period. The task will be a drop down list (I only use 1,2 or 3 for now) and each task will have a different colour. Also, the period will be entered manually (for month to month). For every task and period entered, I need the fields in the sheet Calendar to be automatically filled giving the criteria. For example, if employee xxx1 is assigned to task 1(let's say it's red) from May 2012 to December 2012, in the Calendar tab, a red line should appear automatically next to his name from May 2012 to December 2012. Anyone as a solution for me? Regards! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Variables in Conditional Formatting with Excel 2003 | Excel Worksheet Functions | |||
Conditional Formatting of Checklist with several date variables | Excel Worksheet Functions | |||
Conditional formatting with variables | Excel Worksheet Functions | |||
Conditional formatting for more than 3 variables | Excel Worksheet Functions | |||
formatting variables | Excel Programming |