multiple conditional format

[jshamm]

I have a variance column where the user wants the font color to be red if the variance is more than 5%.  If the variance is up to 5% then the font color needs to be yellow.  Is there any way in report studio to conditionally format text color this way?  Thanks for any input.

[blom0344]

We use a variable with a case to check the value, then use a style variable on the list column body to assign colors according to the outcome of the CASE in the variable.  The variable refers to a query item that translates to a set of values:
Case
when abs([perc]) < 5/100 then 0
when abs([perc]) >= 5/100 then 1
else 2
end

[jshamm]

Thanks blom, I was able to use a string variable to get this to work however I've run into an issue.  I am attempting to highlight a variance intersection in my crosstab report.  currently, the report contains Actual, Budget, Variance, and Variance Percent.  I want the Variance column to be yellow if the variance percent is between 0 and 5% or red if the variance percent is over 5%.

As of now, the variance percent is the only intersection that will change font color even though I applied the conditional format to the Variance column.  Is it possible in version 8.2 to use conditional formatting on one column based on the value in a different column?

[blom0344]

We use this for more complex rowshading within list reports. Works fine..  Have no experience with this within crosstabs though..

[Lynn]

Have you tried setting an advanced conditional style?