GrapeCity.Documents.Excel.IFormatCondition.Text

Text Property

Text

Gets or sets a string value that specifies the text used by the conditional formatting rule.

Use this property to configure the text for a text-based conditional formatting rule. This value works together with TextOperator to define how the rule searches for matching text.

Declaration

string Text { get; set; }

Property Text As String

Examples

worksheet.Range["A1:A3"].Value = new object[,] {{"Pending"}, {"Done"}, {"Pending Review"}};
IFormatCondition condition = (IFormatCondition) worksheet.Range["A1:A3"]
    .FormatConditions.Add(FormatConditionType.TextString, FormatConditionOperator.None, null, null);
condition.Interior.Color = Color.Yellow;
condition.Text = "Pending";
string text = condition.Text;