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

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.

 

[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?