Highlight row cell if value in column a doesn't match in column b in devexpress

Question

can somebody help me, how to highlight row cell if value in column a doesn't match in column b in Devexpress VB.NET. Here is the screenshot

please clarify that which you want to hightling row or cell ? — Sanjay Radadiya, Jul 21 '16 at 03:58

DmitryG · Answer 1 · 2016-07-21T09:06:20.317

Take a look at the Conditional Formatting feature which allows you to change the appearance of individual cells or rows based on specific conditions.

I believe, the FormatConditionRuleExpression will be helpful:

Imports DevExpress.XtraEditors
Imports DevExpress.XtraGrid

Dim gridFormatRule As New GridFormatRule()
Dim formatConditionRuleExpression As New FormatConditionRuleExpression()
gridFormatRule.Column = colA
gridFormatRule.ApplyToRow = True
formatConditionRuleExpression.PredefinedName = "Red Fill, Red Text"
formatConditionRuleExpression.Expression = "[A] != [B]"
gridFormatRule.Rule = formatConditionRuleExpression
gridView1.FormatRules.Add(gridFormatRule)

Brilliant very helpful, thank you very much @DmitryG. – Tedi Suprapto Jul 22 '16 at 13:23 — Tedi Suprapto, Jul 22 '16 at 13:23

Highlight row cell if value in column a doesn't match in column b in devexpress

1 Answers1