Link to home
Start Free TrialLog in
Avatar of csehz
csehzFlag for Hungary

asked on

Excel - Basic project planner (differentiated per Project size)

Dear Experts,

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

BasicProjectPlanner_v3.xlsx

briefly depending on which week number wrote to column J, then for different projects (Project 1, 2 and 3) coloring the length of the project phases with conditional formatting (based on number in column B):

User generated image
Actually but in this version the different Project sizes got different length in phases (in column A the mapping is for Small, Medium and Big, while column C shows the length in Weeks).

Could you please advise how to modify the conditional formatting to work based on the entered project size in column H?

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

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of csehz

ASKER

Saqib thanks for your help again, that works amazing