Conditional formatting Progress Bar if Date is in Cell

I am not clear on your overall scheme. Your Plan bar (blue) uses conditional formatting based on starting on the Plan date in column E and ending on the plan date in column BM. Your Forecast bar (black) does the same thing for columns J to BR. This by itself doesn't make sense to me because you have a lot of dates in between on row 21 that you seem to be ignoring.

I am going to try and guess at what you want to do but I think you should rethink the whole solution.

To do the same thing for your Complete dates, you need to do something similar but look at the earliest and latest Complete dates, instead of the first and last.

Formula:

Please Login or Register  to view this content.

Also note that in your example, something is mismatched. Your Complete bar starts on 11/19/2019 but your first Complete date is 11/19/2020, so your earliest Complete date is 12/9/2019.

Anyway, I have been a systems development project manager for over 30 years and I don't understand what you are trying to show in this Gantt chart.

It doesn't require it. I made a mistake.

It will work but is not what I intended. The correct formula is

Formula:

Please Login or Register  to view this content.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

Originally Posted by JTinKC

Let's suppose I want to color the conditional formatting based on whether or not the forecast was past the plan date. I've been playing around with if statements and I keep coming up short. For example, if the forecast exceeds the plan then the conditional format appears red.

Which bar do you want to apply this to: Plan, Forecast, or Complete? Would you want the whole bar to be red, or just the portion that exceeds plan?

This example colors the portion of the Forecast bar red that exceed the Plan bar.