Highlight row a certain color based on a character from a cell

INVENTORY-TRACKER.xlsx

Hello Excel world,

I have a attached an inventory spreadsheet that I use at work. The only active column that gets data entered into it, is column E "Qty (Pcs)". I enter quantities of inventory in this column.

In column B is the part numbers for product. The letters at the end of the part numbers are associated with certain colors that you can see in the small chart to the right of the report. H=Yellow, M=Blue, S=Green, V=Orange and P=Purple.

What I am trying to achieve is when I type a value in the Qty (Pcs) row. I would love for the entire row that contains data to highlight in the respective color based on what letter is at the end of the part number in column B.

Example - I type 100 in E2 and the entire row of data turns Orange because the V at the end of 13001 is associated with Orange.

Thanks for any help you can give.

Awesome! Thank you so much. I guess I am still very much a rookie after seeing such a simple formula.

Thanks again!!!