Hi,
I am working on a Price Calculator. I need to highlight rows in the below table based on the value of a particular cell $D$6
<tbody>
</tbody>
If $D$6=1, row 1 should be highlighted, if $D$6=2, row 2 to be highlighted and so on.
Any help would be highly appreciated.
I am working on a Price Calculator. I need to highlight rows in the below table based on the value of a particular cell $D$6
Pricing Tiers | Multiplier | Low unit price | Mid unit price | High unit price | Mid price sale Total |
Level 1 Pricing | AMF Cost x 2.5 to 3 times | $22.85 | $25.13 | $27.42 | $2,741.69 |
Level 2 Pricing | AMF Cost x 3.5 to 4 times | $31.99 | $34.27 | $36.56 | $3,655.58 |
Level 3 Pricing | AMF Cost x 4.5 to 5 times | $41.13 | $43.41 | $45.69 | $4,569.48 |
Level 4 Pricing | AMF Cost x 5.5 to 6 times | $50.26 | $52.55 | $54.83 | $5,483.38 |
Level 5 Pricing | AMF Cost x 6.5 to 7 times | $59.40 | $61.69 | $63.97 | $6,397.27 |
Level 6 Pricing | AMF Cost x 7.5 to 8 times | $68.54 | $70.83 | $73.11 | $7,311.17 |
Level 7 Pricing | AMF Cost x 8.5 to 9 times | $77.68 | $79.97 | $82.25 | $8,225.06 |
<tbody>
</tbody>
If $D$6=1, row 1 should be highlighted, if $D$6=2, row 2 to be highlighted and so on.
Any help would be highly appreciated.