troubleshooting Question

Excel - Basic project planner (multiple project lines)

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

Thanks for EE having a simple project planner in the attached file could you please have a look at it:


briefly depending on which week number wrote to cell I2, then in row 3 coloring the length of the project phases with conditional formatting (based on number in column B)

The question simply that it works nicely for Project 1 so on row 3, however could you please advise how to modify the conditional formatting to work also for Project 2 and Project 3 so rows 4 and 5?

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 4 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 4 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