I've been able to change the font using the ConditionalValueAppearance, but is there a way to change Column.Format based on whether the value is negative or positive? For example, I'd like negative values to be surrounded by parenthesis.
Hi,
You don't need conditional formatting for this, this is already built in to formatting in DotNet. Check out the Microsoft documentation on the Numeric formats for the data type you are using.
http://msdn.microsoft.com/en-us/library/0c899ak8.aspx