Colored cells based on drop-down selection

[NateZ]

I am trying to create a spreadsheet which allows me to select an antibiotic from a drop-down menu (refer to cell D1) on Sheet 1.jpg, which would then color the cells below based on the color-coded coverage based on another sheet (refer to D2-D17 of Sheet 2.jpg).

Would REALLY appreciate some tutoring on how to make this happen.

Thanks in advance!!