Is it possible to put a calculated cell on a cube that will change the
fore color based on the value. For instance,
iff(Measures.[Amount]>5000,FORE_COLOR='255',FORE_COLOR='0')

You can do what you want, but somewhat differently. You can create a
calculated cell with forecolor as an mdx expression. Check this out in mdx
sample:

with cell calculation x for '({[Customers].[All Customers].[USA]})' as '1',
back_color='iif(false,1,0)', fore_color='iif(true,255,1)'
select {[Customers].[All Customers].[USA]} on 0 from sales cell properties
formatted_value, back_color, fore_color

--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"Laurie" <whj3ihdey1inz7k (AT) jetable (DOT) com> wrote