Edit column rule (using formula) in table tool

[DannisMen]

Hi, when i use this formula to edit column rule, the backgroud color doesn't show as expected. Can someone tell me what's going on?

If [Credibility (%)] <= 10 then "Background Color: Red"
ELSEIF [Credibility (%)] <= 20 then "Background Color: R=255,G=81,B=81"
ELSEIF [Credibility (%)] <= 30 then "Background Color: R=255,G=105,B=105"
ELSEIF [Credibility (%)] <= 40 then "Background Color: R=255,G=128,B=128"
ELSEIF [Credibility (%)] <= 50 then "Background Color: R=255,G=149,B=149"
ELSEIF [Credibility (%)] <= 60 then "Background Color: R=170,G=225,B=170"
ELSEIF [Credibility (%)] <= 70 then "Background Color: R=149,G=225,B=149"
ELSEIF [Credibility (%)] <= 80 then "Background Color: R=125,G=225,B=125"
ELSEIF [Credibility (%)] <= 90 then "Background Color: R=100,G=225,B=100"
else "Background Color: R=0,G=225,B=0" endif

[echuong1]

I suggest separating these out into separate rules. 

See this article for a sample workflow: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Conditional-formatting-for-specific-ce...

[DannisMen]

I used to have 10 rules but every time i need to create a new table with rules, i have to re-do the ten rules. So is it possible to do it in one rule?

[DannisMen · Accepted solution]

I figured out on my own. 

it has to be:

"Background-color:rgb(255,0,0)"