Articles in this section
Category / Section

How to apply Style to a cell based on it's Value?

1 min read

 

The QueryCellStyleInfo() event can be used to set the style for the cells of the Grid control. The following code snippet shows how the color of text in cells containing value greater than 5 are set as red.

C#

protected void GridGroupingControl1_QueryCellStyleInfo(object sender, Syncfusion.Web.UI.WebControls.Grid.Grouping.GridTableCellStyleInfoEventArgs e)

{

if ((e.TableCellIdentity.TableCellType == GridTableCellType.RecordFieldCell || e.TableCellIdentity.TableCellType ==

GridTableCellType.AlternateRecordFieldCell))

{

if (e.TableCellIdentity.Column.HeaderText == "CategoryID")

{

if ((int)e.Style.CellValue > 5)

e.Style.TextColor = Color.Red;

}

}

}

VB

Protected Sub GridGroupingControl1_QueryCellStyleInfo(ByVal sender As Object, ByVal e As

Syncfusion.Web.UI.WebControls.Grid.Grouping.GridTableCellStyleInfoEventArgs)

If (e.TableCellIdentity.TableCellType = GridTableCellType.RecordFieldCell OrElse e.TableCellIdentity.TableCellType =

GridTableCellType.AlternateRecordFieldCell) Then

If e.TableCellIdentity.Column.HeaderText = "CategoryID" Then

If CInt(e.Style.CellValue) > 5 Then

e.Style.TextColor = Color.Red

End If

End If

End If

End Sub

Sample:

http://help.syncfusion.com/support/samples/kb/Grid.Web/6.1.0.34/GGCCellStyle/CellStyle.zip

Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied