I have this workbook/sheet that was created by EE Professionals that I'm now looking for another enhancement to.
Overview: This Sheet is part of a model to help with scheduling but is not intended to be a replacement for MS Project. When you pick a date horizon (Start/End) it auto sets the model up. The next step here is to add in Tasks. There are 3 types of tasks (Parallel (P), Critical (C) and Milestone (M) - The Milestone must be a single date.
What I'm looking for: I'm looking for a way to have a macro or formula (since the sheet is dynamic (it can expand or contract), I think a macro may be a better way to go, take a task and the identified "type" and set it in the appropriate color and space based on the date. Mocked up version attached.
Much thanks in advance,