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
Bookmarks