MJ Taft wrote:

> I have a report that has a pct avail column where the font is colored
> red, yellow, or green based upon thresholds. The color is based upon
> an IIF formula that compares against the thresholds (db fields).
> When this report is exported to excel, the colors are all red (NOT a
> good thing ... freaks out the customer). They want to keep the
> colors on the report, but would like to eliminate the colors from the
> export to excel if they wont work properly. Also when they click on
> the percent avail they are seeing =IF(_177=0,0,_176/_177) which of
> course makes no sense to them. The expression I am using on the
> color in srs on that field is this:
>
> =iif((me.value * 100)<= Fields!THRESHD_CRITICAL.Value
> ,"red",iif((me.value * 100) <= Fields!THRESHD_WARNING.Value
> ,"gold","green"))
>
> So ... the question is can I do anything about how this exports to
> excel so they dont see all of their percentages as RED (they appear
> correctly colored in SRS on the web)