Have a question about Excel conditionally formatting within the Financial Reporter.

I have a FR report with different columns for each division......is it possible to format that column either red or green depending on if that division is showing a loss or not for that particular month.

It seems that conditional formatting does not carry down from the spec area.......has anyone done this successfully?

Thanks for any and all replies and suggestions.