Forum Discussion
Conditional formatting calendar in a Gantt Chart
I am using a Gantt chart to schedule crews and I would like to have it color coordinated to easily see if anyone is missing from the schedule at a glance. What I want, is that if I pick a name f...
=($C9="ann")*($H9<=J$8)*($I9>=J$8)=($C9="bob")*($H9<=J$8)*($I9>=J$8)Do these rules for conditional formatting return the intended result in the screenshot?
=$J$9:$BN$12This is the range the conditional format applies to.
I made some changes and got rid of a column. But I think some of the formulas that are built into the template are interfering with the formula you suggested.
I tried to modify what you sent to match what is going on with my modified spreadsheet. Not having luck though. I feel like I should be able to edit one of the ones that starts with =AND(NOT(ISBLANK to get the results. But I need to learn the formula stuff better.