Gant Excel Conditional Formatting

[Excel-Access]

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

[Phuocam]

Try:

=WEEKNUM(F4)=WEEKNUM($D$5)

[José Augusto]

Hi

Try to do this CF

Formula: =AND(E$4>=$C5,E$4<=$D5)

Applied to: =$F5:$J5

[Excel-Access]

Thanks but both these solutions do not work.

It is now highlighting just 20th April and not 13th April

Please advise

[JeteMc]

Try the following:

Please Login or Register  to view this content.

Let us know if you have any questions.