asked on Excel - Basic project planner (multiple project lines)
Dear Experts,
Thanks for EE having a simple project planner in the attached file could you please have a look at it:
BasicProjectPlanner_v2.xlsx
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,
Thanks for EE having a simple project planner in the attached file could you please have a look at it:
BasicProjectPlanner_v2.xlsx
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,
Microsoft ExcelMicrosoft Office
Last Comment
csehz
Would it be using the same start and duration data as for Project 1?
ASKER
Yes thanks for the question there would be just one difference, that in column I planning to modify only the Starting weeks (cells I4 and I5 added on the below print screen), while the project phases would be standard
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for your kind help again, it works great like that
