=AND(HLOOKUP(INDEX($G$8:$R$8,COLUMN(G9)-COLUMN($G$9)+1),$C$1:$Y$4,4,YANLIŞ)>=$AC9,HLOOKUP(INDEX($G$8:$R$8,COLUMN(G9)-COLUMN($G$9)+1),$C$1:$Y$4,4,YANLIŞ)<=$AD9)
we can improve the worksheet by changing the CF rules, and go down to a single CF rule.
Ammeded CF formula:
=AND(INDEX($C$4:$Z$4,MATCH(G$8,$C$5:$Z$5,0))>=VALUE(LEFT($C9,FIND("-",$C9)-1)),INDEX($C$4:$Z$4,MATCH(G$8,$C$5:$Z$5,0))<=VALUE(RIGHT($C9,LEN($C9)-FIND("-",$C9))))
Apply to range G9:R27