This rule for conditional formatting works in my sample sheet. This doesn't require VBA code.
=VLOOKUP(LEFT(E2,SEARCH(" ",E2)-1),$I$2:$J$8,2,0)*0.75<G2