Aspose.Cells.Examples.CSharp.Formatting.ConditionalFormatting.AddContainsError C# (CSharp) Method

        private void AddContainsError()
        {
            FormatConditionCollection conds = GetFormatCondition("E17:G18", Color.LightSkyBlue);
            int idx = conds.AddCondition(FormatConditionType.ContainsErrors);
            FormatCondition cond = conds[idx];
            cond.Style.BackgroundColor = Color.Yellow;
            cond.Style.Pattern = BackgroundType.Solid;
            Cell c = _sheet.Cells["E17"];
            c.PutValue("  ");
            c = _sheet.Cells["G18"];
            c.PutValue("  ");
        }
        // This method implements the BeginsWith conditional formatting type.