Conditional formatting with ranges involving text

Hello!

I've been struggling to make this conditional formatting work. The repetitive data in ranges D4:G11, D15:G22, etc. are the people who could potentially be on call during a weekend. The number in column C is the week. I'm trying to add a conditional format to the ranges of names so that the box turns red if that person's preferred weekend(E50:A74) is equivalent to the week # adjacent to the ranges, meaning they can't work. I can't figure out how to incorporate two ranges and multiple discreet values(I.e. the week numbers). I recognize this may require a different equation for each week range, which is fine!

My hope, when I figure that out, was to make it dark red if the adjacent column F values said "All" and light red for all other text values.

So thankful this community exists. Help, please!