Gantt Question

[Liverlee]

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, "")

 

[Herakles]

Are you able to use XL2BB to indicate which rows and columns we are looking at?

Have you looked at the star icon set in Conditional Formatting?

 

[Liverlee]

ah sorry, here's the columns.

i've tried this formula =IF($G3=($E4-WEEKDAY($E4,2)+1),UNICHAR(11088),"") with a unichar character and when I drag across and down this is what I end up with

 

[Liverlee]

=IF($G3=($E4-WEEKDAY($E4,2)+1),UNICHAR(11088),"")
=IF(G$3=($E4-WEEKDAY($E4,2)+1),UNICHAR(11088),"") this works

 

[Herakles]

Great.

UNICHAR(10039) allows the forground to be set.