Edit column rule (using formula) in table tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I figured out on my own.
it has to be:
"Background-color:rgb(255,0,0)"