I have attached a Gantt Chart styled spreadsheet I am currently using to project the "Level of Effort throughout an entire day. Right now I simply type in the Event Start & End times and give it a Description. The conditional formatting handles the creation of the fill areas. I now also want to add a Level Of Effort scale (1 - 5) to each event. With a subtotal of the LoA at the bottom of the table for each half hour span of time. Right now I enter the LoA into column D. Then I also have to add it to the conditionally formatted cells and drag across. Is there a way to carry over the LoA # from column D into only the conditionally formatted cells. I would like to just add LoA into Column D, and it would auto populate where the conditional format has filled.
Bookmarks