Example - Mechanical Inspection using AQL

AnthonyCappuccio 

I'd do that with helper ranges/cells. For the main table

add percents as numbers, not as texts on the top, and on the left low boundary of ranges.

Here

in B1 how we interpret ALL, and in C1 formula

=IFERROR(
   --INDEX(TABLE!$D$5:$S$19,
      LOOKUP('TAB 1'!$E$3,TABLE!$A$5:$A$19,(ROW(TABLE!$A$5:$A$19)-ROW(TABLE!$C$4))),
      MATCH('TAB 1'!$E$5,TABLE!$D$3:$S$3,1)),
'TAB 2'!$B$1)

and conditional formatting rule formula as

=(ROW()>ROW($C$2))*(ROW()<=($C$1+ROW($C$2)))

It could be combined al together in one formula, but it will be hard to maintain such.