Not applicable
2010-09-15
08:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Change background cell color in the chart table
I have an expression to change background color of a cell on
=If([Technology Status]='AAA',lightgreen()) -
works fine but I do have multiple statuses so I want to color them in different colors.
Such as:
=If([Technology Status]='XYZ',lightblue()) and
=If([Technology Status]='xxx',red()) and so on
How do I use nested if or is there any better way? Thanks, yury
12,080 Views
- « Previous Replies
-
- 1
- 2
- Next Replies »
11 Replies
sergio0592
Specialist III
2017-06-04
12:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Enrique,
You must write the name of the color field. In my exemple below, the name of the field color is JudgColor.
JudgmentsColors:
LOAD *
,rgb(R,G,B) as JudgColor
INLINE [
Judgments,R,G,B
critical,255,28,28
major, 255,255,45
minor,0,128,255
];
quiquehm
Contributor III
2017-06-07
03:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Jean ! I tried it and it works perfect !
rgds
Enrique
- « Previous Replies
-
- 1
- 2
- Next Replies »