Hello
Can anyone help me out with this problem? I have a lovely Gantt that increments weekly. I have tasks and I have milestones. I'm trying to create a formula so if column c says "M" for Milestone a star will appear in the relevant cell but I'm running into a brick wall cos the dates increment weekly. so I can't drag formula's across and down.
I've added a conditional formatting icons - 1 = star.
But I cannot get any formula to fill cells G4:BJ50 with a 1 - this just doesn't work for some reason =IF(AND($B4="CT Productivity", $D4="M", $E4>=$G$3, $E4<=$H$3), 1, "")
Can anyone help me out with this problem? I have a lovely Gantt that increments weekly. I have tasks and I have milestones. I'm trying to create a formula so if column c says "M" for Milestone a star will appear in the relevant cell but I'm running into a brick wall cos the dates increment weekly. so I can't drag formula's across and down.
I've added a conditional formatting icons - 1 = star.
But I cannot get any formula to fill cells G4:BJ50 with a 1 - this just doesn't work for some reason =IF(AND($B4="CT Productivity", $D4="M", $E4>=$G$3, $E4<=$H$3), 1, "")