Show Negative Number In Red Using DataFormat string

[Tracy]

Hi,

Is there a way to use the dataformatstring on a gridboundcolumn to display negative numbers in red?

DataType="System.Int16" DataFormatString="{0:#,###,##0;-#,###,##0}"

Thank You
Tracy

[Princy]

Hi Tracy,

You can set the negative numbers to be in Red,from code behind by accessing the column values.Please try the following and let me know if any concern.

ASPX:

<telerik:GridBoundColumn DataField="EmployeeID" HeaderText="EmployeeID" UniqueName="EmployeeID" DataType="System.Int16" />

C#:

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
    if (e.Item is GridDataItem )
    {
        GridDataItem data = (GridDataItem)e.Item;
        int value = Convert.ToInt16(data["EmployeeID"].Text);
        if (value < 0)
        {
            data["EmployeeID"].ForeColor = Color.Red;
        }
    }
}

Thanks,
Princy

[Tracy]

Hi Princy,

Thanks for your response.  I was just hoping I could do it with the DataFormatString.

Thank You
Tracy