Conditional Formatting based on Combo Box Selection

Hey all,

I am employed by an ice cream manufacturing plant, and have been tasked with creating a spreadsheet that records production line filler speeds. For each production line, there are "x" number of products that are run on that line, and each product is run at a different filler speed.

My end goal is to create a spreadsheet that allows the user to input hourly updates - including the time, product being run, and current filler speed. If the speed entered is below the standard "reference" speed of that line, in other words what speed we should be running at, it should highlight the cell red to call out the need for explanation.

For the speed standards - I have gotten as far as creating a "Product List" worksheet, in which each column is a particular production line, and each row pertains to a particular product on that line. The adjacent column would list the reference speed for each product per line. I have also drafted a worksheet for operators to enter their data. Instead of entering the product manually, however, I have created a combo box that references my Product List worksheet and pulls product names from that sheet.

Now I need a little help tying it all together. For each cell that allows line speed to be entered, I need Excel to first look up which selection has been made in the combo box (figured out how to display the index number using Cell Link, and how to display the combo box selection based on the index number, but that's as far as I got), cross-reference this with my Product Worksheet to determine what the line speed should be, and highlight the cell red or no highlight based on if the entry is above or below the standard.

I was thinking of different ways to tackle this... the IF statement with multiple conditions came to mind.. i.e. IF combo box = Product X AND Filler Speed < Product X Standard Reference Speed, THEN color box red. But for each entry cell I would need an IF statement for every single product.. right? With 49 different products on one line alone (one combo box), I can only imagine the formula being as long as Pi. Is there an easier way to go about this? Is this possible??

Thanks for any help you all can provide!! Here are some visual aids:

In this worksheet, the operator enters Time, Product (via combo box), and DPM (filler speed). The DPM number here is what needs to be highlighted if it falls out of spec.
linespeeds.JPG

In this worksheet, the products are broken down into columns by line. The DPM (filler speed) listed here is the reference speed of the filler, the standard speed. If the number entered in the previous sheet falls below this spec, the cell on the previous sheet needs to be highlighted red.
productlist.jpg