Use conditional formatting to highlight the loans with an origination amount that exceeds the limit for that type of loan.

Use the Loan Types and Maximum Loan Amounts Table on the Loan Types worksheet

Highlight "Origination Amount$($s$)"$ in column E for any loans with an Origination Amount that exceeds the limit for that type of loan using a green background fill color.

You will need to use a vlookup to obtain the maximum loan amount in the conditional formatting rule. Use the named range "loantypes" in the vlookup.