Forum Discussion
Solved
Conditional Formatting Not applying to cells
Hi All, I am in the process of developing a Gantt Chart and using Conditional Formatting to fill the cells from data in adjacent cells. Unfortunately, if I change the sequence from what would be...
njconsult I did some testing and arrived to a CF formula that works for the weekly actual
view.
=AND(K$5>=$F8-WEEKDAY($F8,2)-1,K$5<=WORKDAY($F8,$G8-1,2))
The one for the daily actual view would be:
=AND(K$5>=$F8,K$5<=WORKDAY($F8,$G8-1,2))
Please see if this indeed works out for you
njconsult I did some testing and arrived to a CF formula that works for the weekly actual
view.
=AND(K$5>=$F8-WEEKDAY($F8,2)-1,K$5<=WORKDAY($F8,$G8-1,2))
The one for the daily actual view would be:
=AND(K$5>=$F8,K$5<=WORKDAY($F8,$G8-1,2))
Please see if this indeed works out for you
- Hi Riny,
Thank you so much this worked!
