Grid conditional formatting

[Jon Shuler]

I was trying to implement conditional formatting in the Grid control by using the GridQueryCellInfoEventHandler.  I want to change the BackColor based on the value of the cell.  The Style property of GridQueryCellInfoEventArgs has CellValue and Text properties but they are always blank.  Any hints on how this can be implemented?

Thanks

Jon

[Arulpriya Ramalingam]

Hi Jon, 

Thanks for your interest in Syncfusion products. 

In order to achieve the ConditionalFormatting based on cell value, the PrepareViewStyleInfo event can be used. In that event, e.Style.BackColor property can be used to set the back color. Please make use of below code and sample, 

Code snippet 

 

//Event Triggering 

gridControl1.PrepareViewStyleInfo += GridControl1_PrepareViewStyleInfo; 

 

//Event Customization 

private void GridControl1_PrepareViewStyleInfo(object sender, GridPrepareViewStyleInfoEventArgs e) 

{ 

    if (e.Style.CellValue.ToString() == "AAAA") 

    { 

        e.Style.BackColor = Color.Yellow; 

    } 

} 

 

UG links: how-to-add-conditional-formatting-to-rows  

how-to-change-the-back-color-and-text-color-of-the-selected-item 

 

Sample link: http://www.syncfusion.com/downloads/support/forum/130492/ze/CellGrid_20152071212721  

 

Regards, 

Arulpriya