• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Gantt Excel Conditional Formatting

E

Excel-Access

Member
Hi Excel Community

Could someone assist me in modifying the formula in the Excel conditional formatting so it draws the correct Gant chart.

I have Friday's week ending on the top for say April 2018 but in the example I have attached it is not picking he correct dates.

Seems to work if I have every day in April but not for Fridays week ending.


Thanks
 

Attachments

  • Gant Excel Conditional Formatting.xlsx
    10.9 KB · Views: 11
In the test for end date, use the Monday for comparison purposes
= AND((F$4>=$C5), (F$4-4)<=$D5) [i.e. Friday - 4]

The formula could be placed within the conditionally formatted range if you wanted to. Then all your conditional formatting tests would reduce to the same thing, that is testing for cells that contain TRUE. You would need to include font colour as part of the conditional format so that the Booleans are not visible.
 
You must log in or register to reply here.
Back
Top