I would like to create a gantt chart that shows multiple sub steps. Each would have a planned days & hours and then an actual days & hours. Those would be shown by highlighting the cells to the matched list above. More steps should be able to be added if need be, maybe by just clicking a button if possible. I have the expected outcome attached as an excel doc. Let me know if you need anything else to make this work.
Perhaps this will help.
This proposal employs four conditional formatting rules
For days planned: =AND($B5="Plan",D$2<=$C5)
For hours planned: =AND($B4="Plan",D$3<=$C5)
For days actual: =AND($B5="Actual",D$2<=$C5)
For hours actual: =AND($B5="Actual",D$3<=$C5)
All rules are applied to the range: =$D$5:$M$30
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Would there be a way to have a button to add steps/substeps to then just autopopulate the formulas you have there for actual vs. planned?
That is probably a question that someone from the Excel Programming / VBA / Macros forum could answer if you would like to ask one of the moderators to move this thread over there.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks