Conditional color formatting on percentage

[LP27]

Hi Folks,

I have straight tabel,

I am creating If condition as -

 if([Defect Code - Desc] = 'N/A', 'No', (1-(sum(DefectValue)/Sum([Measures.1.1 Scrap QAP(s900)])*100)))

This condition works well and it produces  a percentage in column as  shown below-

Percentage

100%

95%

85%

Now i need to color  format the percentages in the column as - 

If percentage is below 80% = Red

if percentage is higher than 95% = Green

If percentage is between 80% - 95% = Yellow

Not sure how to code this in Straight table, under Background color Expression in Percentage field.

Thanks in advance.

Regards,

LP27

[Diter]

Hi
May be you can use all formula as:
if(...….*100)))<80, rgb(255,0,0),
if(...….*100)))<95, rgb(255,215,0),
if(...….*100))) >95, rgb(0,128,0))))

hope this help

regards,