I am trying to change the color of text based on the data
i added conditional formatting to the text based on a variable ‘PrintInColor’. that works
now i wanted to supply the color via the data model but i noticed that in the color settings of the conditional formatting i cannot access my data model
i tried creating a user variable but while i can access the user variable in the color settings it looks like it gets converted to a fixed value
Where exactly are you trying to add the conditional format? Is this a table or a crosstab? Or a text object? If you provide some more details we can easily have a closer look .
Hi Mike, as promised I tried to repro this issue. I used the standard sample “Table in Table” for our demo application. Here, for the price column of the nested table I added a conditional formatting like so:
the result is just the same. Can you try to find the difference between your project and the sample project? I’m attaching the modified version with the “complex” formula.
Upon closer reading the problem might be in the conditional formatting - it always works on the content of the cell the format is applied to. Thus, the second approach might be more appropriate for you.