ah_mktanlys_01
New Member
I am creating a Gantt Chart to create a calendar to track events. A have created these before but for some reason I am getting an error with the conditional formatting to show the range for start and end date. I have a pivot table that shows the Event Name, Assignee, Start Date, End Date, Duration, Progress, etc. I have a formula where I can select different views for day, week, and month.
This is the equation that I am entering =AND(J$7>=$E8,J$7<=$F8)
I have tried a couple of different Excel files to see if it was an error in the file but I am still having the same problem. When I first apply the conditional formatting, no formatting shows, and I notice the equation changes to this:
View attachment 109413
When I fix it to be $E8, it when shows one line of color but not correctly based on the start and end date and not for all rows. I am wanting to apply it for rows past what is currently there (until row 1,000) that way as we add data to the data tab, the gantt chart will update.
Can someone help me figure out why it is doing this? I have tried even a different gantt format and it is not working. A template of my excel file is attached.
This is the equation that I am entering =AND(J$7>=$E8,J$7<=$F8)
I have tried a couple of different Excel files to see if it was an error in the file but I am still having the same problem. When I first apply the conditional formatting, no formatting shows, and I notice the equation changes to this:
View attachment 109413
When I fix it to be $E8, it when shows one line of color but not correctly based on the start and end date and not for all rows. I am wanting to apply it for rows past what is currently there (until row 1,000) that way as we add data to the data tab, the gantt chart will update.
Can someone help me figure out why it is doing this? I have tried even a different gantt format and it is not working. A template of my excel file is attached.
