Conditional format project timeline based on milestone in sub task

Good morning,

I am trying to find a way to have the milestone that is in a task, reflected in the total project timeline. For example, in the attached, I have the milestone conditional formatted to shade in black; I'd like that to reflect in the appropriate week in the total project timeline. I've not been able to figure out what I need to add in order to do that. Thank you so much!

Hi - to make sure I understand, are you saying that if Column A has a M you want a cell to be colored black?

Hello! yes that is correct! I can get it to do that in the task but can't figure out how to get it in the overall project timeline that is above it. (For example I can get it show black in row 10 but not row 7.)

OK so if I put a M in 7A then H7 to AE7 turn black.

Try this as the CF formula for row 7

=SUMPRODUCT(($D$8:$D$200>=H$3)*($E$8:$E$200<=I$3)*($A$8:$A$200="M"))

Not in the file I sent: columns J and K are highlighted (where there is a 1 in column 6)

=SUMPRODUCT(($D$8:$D$24>=H$3)*($E$8:$E$24<=I$3)*($A$8:$A$24="M")) in row 6

will show 1 for weeks 3 and 4

Check I did not make an error: H$3 not $H3

You're absolutely correct; the file you sent was correct. I must have had a conflict when I tried to recreate your solution. Thank you so much for your help!!!!

Glad it's sorted.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.