IsStrikeThrough Property

Gets or sets a Boolean value indicating whether the font is strike through.
Property IsStrikeThrough As Boolean
Dim instance As IConditionalFormat
Dim value As Boolean
instance.IsStrikeThrough = value
value = instance.IsStrikeThrough
bool IsStrikeThrough {get; set;}
Similar to IsStrikeThrough, we can use Underline, IsBold and IsItalic properties to format the values in the cells within the conditional formatting range.
Data in the cells within the conditional formats range can be struck with the help of IsStrikeThrough property. To strike values in the cells, we have to set the IsStrikeThrough property to True.
using Syncfusion.XlsIO;
using System;
using System.Drawing;
class Example
    static void Main()
        using (ExcelEngine excelEngine = new ExcelEngine())
            //Create a worksheet.        
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet worksheet = workbook.Worksheets[0];
            //Load data to Apply Conditional Formatting.
            worksheet["B1"].Text = "Conditional Formats";
            worksheet["B2"].Number = 10;
            worksheet["B3"].Number = 20;
            worksheet["B4"].Number = 30;
            worksheet["B5"].Number = 40;
            worksheet["B6"].Number = 50;
            worksheet["B7"].Number = 60;
            worksheet["B8"].Number = 70;
            worksheet["B9"].Number = 80;
            worksheet["B10"].Number = 90;
            worksheet["B11"].Number = 100;
            //Create instance of IConditonalFormat and IConditionalFormats.
            IConditionalFormats formats = worksheet["B2:B11"].ConditionalFormats;
            IConditionalFormat format = formats.AddCondition();
            //Set Condition.
            format.FirstFormula = "60";
            format.SecondFormula = "20";
            format.Operator = ExcelComparisonOperator.Between;
            //Set StrikeThrough.
            format.IsStrikeThrough = true;
            //Save and Dispose.

Syncfusion.XlsIO.Base: 17.1460.0.32

See Also