troubleshooting Question

Excel - Basic project planner

Avatar of csehz
csehzFlag for Hungary asked on
Microsoft ExcelMicrosoft Office
2 Comments1 Solution21 ViewsLast Modified:
Dear Experts,

Could you please have a look on the attached Excel file,

BasicProjectPlanner.xlsx BasicProjectPlanner.xlsx

basically would like to have a basic project planner.

Briefly there is a kind of control sheet in columns A-B with defining when the project starts as 'Starting week', while there are three phases 'Design', 'Validation', 'Execution' with a number that how many weeks they need to complete:

The target would be what can be seen in columns I-AH with colors,so depending on the numbers in column B, that many cells should be colored by Excel with some automatic logic:

Just an example to see the logic, so if the 'Starting week' would be 12, the 'Design' 2, 'Validation' 3 and 'Execution' 4, then the timeline should be a following:

Being not sure technically how that could be executed, in some other files have seen that such solutions are often based on Name manager and Conditional formatting (of course welcoming any suggestion, except macros as would like to avoid the use of them in this case)

Thanks in advance,
Saqib Husain

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros