Link to home
Create AccountLog in
Avatar of csehz
csehzFlag for Hungary

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)
User generated image
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?

User generated image
Thanks in advance,
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Would it be using the same start and duration data as for Project 1?
Avatar of csehz

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

User generated image
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of csehz

ASKER

Thanks for your kind help again, it works great like that

User generated image