Apply conditional formatting to another column

[Richard Slade]

Hi, 

I need to change the font colour of a cell value when I don't have access to CellElement (I understand that in the new version of the grid, this is a problem)

Is it possible to apply conditional formatting to a column based on the value of a different column?

For example: 
If in Row 1, the value of Cell X = 123 then add a conditional formatting object to Cell Y

Thanks
Richard

[Jack]

Hello Richard Slade,

Thank you for this question. Yes, this is possible. Please check the "Grid View - Customize - Formatting with Code" example in our demo application. It demonstrates exactly the described case.

Should you have any further questions, I will be glad to help.

Kind regards, Jack
the Telerik team

[Richard Slade]

Thanks Jack, but as I said, I don't have access to the RowElement at this point. 
I need to loop over the Rows in the grid 

For Each row As GridViewRowInfo In Me.GridViewProducts.MasterTemplate.Rows

and therefore only have access to RowInfo.

At the moment, I am applying some conditional formatting... 

If Not .ProductCodeOk Then
    Dim codeFormatter As New ConditionalFormattingObject("product", ConditionTypes.Equal, row.Cells("code").Value.ToString(), "", False)
    codeFormatter.CellForeColor = System.Drawing.Color.Red
    Me.GridViewProducts.Columns("code").ConditionalFormattingObjectList.Add(codeFormatter)
    hasErrors = True
End If

But of course I cannot say... 

If Not .ProductCodeOk Then

    Dim codeFormatter As New ConditionalFormattingObject("product", ConditionTypes.Equal, row.Cells("SOMETHING ELSE").Value.ToString(), "", False)

    codeFormatter.CellForeColor = System.Drawing.Color.Red

    Me.GridViewProducts.Columns("code").ConditionalFormattingObjectList.Add(codeFormatter)

    hasErrors = True

End If


[Jack]

Hi Richard Slade,

You can cause RowFormatting event to fire at any point by calling the Update method of GridTableElement or the InvalidateRow method of the row:


Me.radGridView1.TableElement.Update(GridUINotifyAction.StateChanged)

' or

Me.radGridView1.Rows(5).InvalidateRow()

I hope this helps. 

Sincerely yours,
Jack
the Telerik team

[Richard Slade]

Thanks. Used a variant of this and that has worked for me. 
Cheers
Richard