nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Reporting

Accepted answers

DannisMen

I figured out on my own.

it has to be:

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

All comments

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-cells-in-a-table/td-p/404661

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?

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15907

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703