Manipulate Data Formats within cells

[Jeremy Pryor]

How would I change the font weight and color of the values in a particular cell based on a caculcation between 2 other cells.  For instance, when Accounts Receivable is less than Accounts Payable (both are grid columns) how would I format the Total revenue column so that the values in them are Red and bold and when the opposite is true, then how would I format it to bold and black?

[Jack]

Hi Jeremy Pryor,

You should use CellFormatting event in this case. Please check your previous forum post for more detail - 268627. Should you have other questions, don't hesitate to ask.

Regards,
Jack
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Jeremy Pryor]

I have tried to access the CellFormatting event in the radGridView, but I am unable to see it as a valid event for the control.  Please see my attached screenshot.

Thanks,

Jeremy

[Robert]

Hello Jeremy,

In looking at the screenshot you've posted, it looks like you are using the RadControls for Silverlight. Am I correct in assuming this? This forum is actually for the RadControls for WinForms. The RadGridView for Silverlight has an API very different from the RadGridView for WinForms. You can find the GridView for Silverlight forum here. I apologize for any confusion this may have caused.

This forum post in the Silverlight forum might be similar to what you are looking for:

http://www.telerik.com/community/forums/silverlight/gridview/conditional-formatting-in-gridview.aspx

For any WinForms control users that run across this post, here is how you can set up cell formatting to do what Jeremy has described:

        private void radGridView1_CellFormatting(object sender, Telerik.WinControls.UI.CellFormattingEventArgs e)
        {
            // Total Revenue Formatting
            if (e.CellElement.ColumnIndex == 2)
            {
                // accounts receivable > accounts payable
                if (((int)e.CellElement.RowElement.RowInfo.Cells[0].Value) > ((int)e.CellElement.RowElement.RowInfo.Cells[1].Value))
                {
                    e.CellElement.ForeColor = Color.Red;
                    e.CellElement.Font = new Font(e.CellElement.Font, FontStyle.Bold);
                }
                else // accounts receivable < accounts payable
                {
                    e.CellElement.ForeColor = Color.Black;
                    e.CellElement.Font = new Font(e.CellElement.Font, FontStyle.Bold);
                }
            }
        }

Thanks,

Robert

[Jeremy Pryor]

Jack,

Thank you for the help.  I apologize for posting this in the incorrect forum.