I have a spreadsheet that I need it to use a 2 color from white to red conditional format. I have two different conditions I need it to meet.

For Example,

If cell A1 says P2, then check cell B1 to see where it falls in the table below. I need the color to get closer to red as the number in cell B1 gets closer to meeting SLA.

Priority SLA
P1 12
P2 36
P3 400