Conditional Formatting works only after highlighting the table

[sabrez]

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

[TABLE="class: grid, width: 818"]
<tbody>[TR]
[TD]Pricing Tiers[/TD]
[TD]Multiplier[/TD]
[TD]Low unit price[/TD]
[TD]Mid unit price[/TD]
[TD]High unit price[/TD]
[TD]Mid price sale Total[/TD]
[/TR]
[TR]
[TD]Level 1 Pricing[/TD]
[TD]AMF Cost x 2.5 to 3 times[/TD]
[TD]$22.85[/TD]
[TD]$25.13[/TD]
[TD]$27.42[/TD]
[TD]$2,741.69[/TD]
[/TR]
[TR]
[TD]Level 2 Pricing[/TD]
[TD]AMF Cost x 3.5 to 4 times[/TD]
[TD]$31.99[/TD]
[TD]$34.27[/TD]
[TD]$36.56[/TD]
[TD]$3,655.58[/TD]
[/TR]
[TR]
[TD]Level 3 Pricing[/TD]
[TD]AMF Cost x 4.5 to 5 times[/TD]
[TD]$41.13[/TD]
[TD]$43.41[/TD]
[TD]$45.69[/TD]
[TD]$4,569.48[/TD]
[/TR]
[TR]
[TD]Level 4 Pricing[/TD]
[TD]AMF Cost x 5.5 to 6 times[/TD]
[TD]$50.26[/TD]
[TD]$52.55[/TD]
[TD]$54.83[/TD]
[TD]$5,483.38[/TD]
[/TR]
[TR]
[TD]Level 5 Pricing[/TD]
[TD]AMF Cost x 6.5 to 7 times[/TD]
[TD]$59.40[/TD]
[TD]$61.69[/TD]
[TD]$63.97[/TD]
[TD]$6,397.27[/TD]
[/TR]
[TR]
[TD]Level 6 Pricing[/TD]
[TD]AMF Cost x 7.5 to 8 times[/TD]
[TD]$68.54[/TD]
[TD]$70.83[/TD]
[TD]$73.11[/TD]
[TD]$7,311.17[/TD]
[/TR]
[TR]
[TD]Level 7 Pricing[/TD]
[TD]AMF Cost x 8.5 to 9 times[/TD]
[TD]$77.68[/TD]
[TD]$79.97[/TD]
[TD]$82.25[/TD]
[TD]$8,225.06[/TD]
[/TR]
</tbody>[/TABLE]

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.

 

[Norie]

There's a problem with the link you posted, it says the 'page does not exist'.

 

[sabrez]

There's a problem with the link you posted, it says the 'page does not exist'.

Can you please check again?

https://app.box.com/s/5fygnl7igj83c1bhyx2yzy68srkkmmjt

https://app.box.com/file/267377438734

 

[Norie]

The conditional formatting is working for me when I select a Pricing Tier from D6.

Is there anything else going on in the sheet, perhaps something that's not in the version you uploaded?