Relative Conditional Formatting in Crosstab

[bdouglas]

What I have is a crosstab report with every day of the year, months in the columns and day of the month as the rows.  What I want is to have a relative conditional format that will add a background coloring of say green for the best days to red for the worst days.  Specifically I'm thinking of Excel's conditional formating and replicating it within report studio.

I've failed so far on coming up with a method of applying a relative format.  The best I can figure out is just hard coding values with colors (IE 1-25 = red, 26-50 = yellow, 51-75 = light green, 76+ = green) but what I want is to basically rank each day and take the bottom 25% and make it red, etc.  I've tried using ranks and always get stuck with parsing errors when applying the conditional format based on a calculation.

Any suggestions?

Thanks in advance.

[MMcBride]

Dredging this up a bit...
Were you ever able to find a solution to this problem?

I have a Crosstab where I need to do essentially the same thing

We have 9 categories each category shows a % of total for that row.

Row 1
Cat1 = 5%, Cat2 = 20%, cat3 = 10%, cat4 = 10%, cat5 = 5%, cat6 = 20%, cat7 = 5%, cat8 = 10%, cat9 = 15%
Row 2
Cat1 = 15%, Cat2 = 7%, cat3 = 3%, cat4 = 10%, cat5 = 25%, cat6 = 20%, cat7 = 5%, cat8 = 5%, cat9 = 10%

We need to apply a color range so the lowest Categories for each record show green and the highest show red

This is something easily accomplished in Excel and our users want the same conditional format now that
(if we ignore the fact they must key in the values, and apply the conditional rule each month... where the data is automatic within Cognos...)

The examples I have given are pretty common but we do have some where the categories are all below 5% except for one that contains the remaining.

I have the cross tab working perfectly - the Percents are coming in great
In MS Excel you simple select conditional formatting - pick the "3-Color Scale)" - assign the cell range - then for Minimum select "Lowest Value", Midpoint "percentile", Maximum Highest value - pick the three colors you want and Excel creates a pretty color scale for you...

Any thoughts or ideas?

[ebaron5760]

I realize this is a late post to an old question.

Has anyone seen an answer to this? I have the same problem.  :(

thanks!!