-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
phases
-
B
Master Schedule: Conditional Format based on Date
I have a master schedule file to compile projects from various managers. There are four phases with start/end dates. I'd like to be able to enter the dates for the phases, and have the colors change in the cells to the right of the dates based on the entered dates. Is this a stacked conditional...- Boutspers
- Thread
- based dates master phases schedule
- Replies: 3
- Forum: Excel Questions
-
J
One line Gantt Charts
Gantt charts typical display a different task or job on different lines. So one project will have five lines if it has five different phases. It it possible to create a Gantt chart with all phases on one line? I want to be able to look at different projects and see how their timelines match up...- jasonkgreen
- Thread
- charts gantt line phases projects
- Replies: 1
- Forum: Excel Questions
-
B
help with creating an overview of the data in a table
Hi I have an excel sheet that I use to track Manager development across my business. Currently I have a Data entry sheet that has the below columns (There are ten phases so 1 to 10, plus the info before to allow me to filter) Regional Manager - First Name - Last Name - Job Role - Location -...- braidp
- Thread
- completion data manager phase phases
- Replies: 0
- Forum: Excel Questions
-
A
Cell Reference in a different tab
I have a formula, "=IF(phases!C5="IN","IN","OUT")", in a different tab that asks for data from the "phases" tab. However, when I have to filter or sort the "phases" tab data, the data that was in cell C5 moves to another cell but the formula in the other tab keeps the "phases" tab cell...- alzasp
- Thread
- cell data phases reference tab
- Replies: 1
- Forum: Excel Questions
