How to apply Style to a cell based on it's Value?
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