then I used "RGB(X,Y,Z)" as background color in the expression.
The described procedure works perfectly but now is the challenge: I try to make that selection dynamic (for example if Selection <> Function it should take another inline as basis for coloring). It seems that the background color function doesn't allow any functions.
When I try =if(Selection='Function',RGB(X,Y,Z),if(Selection='Sector',RGB(A,B,C),...) it always shows the 'else' value. Does anyone have an idea how to solve that issue?
An idea how the color selection could be made dynamically (in reason of changes in the dataset) would be awesome!
If the formula you are using always uses the "else" then it is not finding the first part of the if statement. I see where you have "Sector" as the 'else'. I don't know where that is coming from in the table?
If the values you want to change color are numbers you can simply set up ranges?
Or if they are specific values, you could simply add a field to the table that has the RGB and whenever that selection is made, it automatically selects the RGB associated with it in the table?