Excel Export Loses Cell Colour

Hi,

I was hoping somebody could give me a little advice. I've added an extra colour into the main style sheet as per below:

.pivotTable .cell-style-blue {
background-color: #0000ff;
}

This display perfectly in the report when using the following expression:

Case
When [Measures].CurrentMember > 49.00
Then '|#,##0|style=blue'
When [Measures].CurrentMember > 19.99
Then '|#,##0|style=green'
When [Measures].CurrentMember > 5.00
Then '|#,##0|style=yellow'
When [Measures].CurrentMember < 4.99
Then '|#,##0|style=red'
Else '|#,##0'
End

The problem I am having when I export to PDF or Excel the new style of blue does not get exported through and I end up with a standard white cell.
Any idea's on what I would need to do to resolve this problem.

Thanks
Mike

I haven't created a report using a MDX so perhaps it is different but could you use a style expression in the bg-colour attribute?

The 'style' property only supports red/green/yellow in PDF and Excel. You should use the 'color' property instead.
Ex.
...
Case
When [Measures] .CurrentMember > 10000
Then '|#,##0|"color=#FF00000"'
....