Create Dynamic Project Timelines in Excel with Conditional Formatting

🏷️Don't forget to use promo code "MINTY50" for a 50% discount during checkout!

If you like this video, drop a comment, give it a thumbs up and consider subscribing here:

Check out my courses on Udemy:

Music from:
YouTube Audio Library

Follow me on Instagram:

Read my articles on Medium:

Subscribe to Magnimetrics for Financial Analysis and Excel tutorials:

#Excel #Timeline #ConditionalFormatting

[hoangthuaduy]

Awesome!! Excellent explanation.. This is exactly I was looking for. Thank you so much for the video!!

[jackwerch]

Is there a way to change the color of the highlight based on a specific team performing the activity?

[philmonhaile]

How would you account for a “Yearly” option on the timeline if I wanted one?

[crowsandcrows]

Hi! Hope you see this. I am really struggling right now😢
Will this still works even if i changed the start or end date?

[mariettequinn]

Awesome! Is there a way to make this a 12 month timeline (with no year) and have it expand and contract depending on what view you are looking at? 365 days or 52 weeks or 12 months? I want to create a cyclical work timeline. Also hoping to group it by semester: fall, spring, summer with fixed dates, fall from 08/16 to 12/31, spring from 01/01 to 05/15 and summer from 05/16 to 08/15?

[Dennis-pjqt]

Thanks a ton! Really great video, easy to follow. Saved me a lot of time. Is there a way to retrieve the "task" text from column B and place it over the yellow bars? I tried =IF(AND(I9.Interior.Color = RGB(91, 155, 213), H9.Interior.Color <> RGB(91, 155, 213)), B9, ""), but since the cells have conditional formatting the formula does not recognize the color.

[davidworthington]

Great video is there a way to add second condition for example planned start date 4/7/22 going take 3 days so should end 6/7/22 but actual end date is 8/7/22 hoe to have that extra day as gone over a different color

[MajaWilhelm-ff]

@mintyanalyst is there a way you can add to the formula to make the formatting cell colour change based on another column e.g. a status column or category column?

[rambabu]

Awesome!! Excellent explanation.. This is exactly I was looking for. Thank you so much for the video!!

[carlosdonoso]

is there a way to add a milestone by using a symbol or character?

[bubbyshines]

Great vid! How can we do quarterly or monthly view?