FarPoint.Win.Spread.TextConditionalFormattingRule text = new FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.Contains, "=C1", true);
// Cell (1,1) must contain the text you type in C1
text.BackColor = Color.Red;
fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, text);
Dim Text As New FarPoint.Win.Spread.TextConditionalFormattingRule(FarPoint.Win.Spread.TextConditionOperator.Contains, "=C1", True)
' Cell (1,1) must contain the text you type in C1
Text.BackColor = Color.Red
fpSpread1.ActiveSheet.SetConditionalFormatting(1, 1, Text)