How to? Conditional Formatting

Aspose.Cells Product Family
1

Is conditional formatting avalible with this component? If so how can I use this and do you have any examples?

2

You can set conditional formatting in your template file and Aspose.Excel can import and export it.

Or you can just make some condition settings in your template and use Worksheet.CopyConditionalFormatting to copy them to other cells at run time.

3

@technix,
Aspose.Cells has replaced Aspose.Excel that is no more available now. This new product Aspose.Cells has rich features for applying conditional formatting to data in a worksheet. Here is an example that demonstrates this feature.

// Set conditional formatting
Workbook workbook = new Workbook();

Worksheet worksheet = workbook.Worksheets[0];
// Adds an empty conditional formatting
int index = worksheet.ConditionalFormattings.Add();
FormatConditionCollection fcs = workbook.Worksheets["Sheet1"].ConditionalFormattings[index];

int[] data = new int[] {30,31,32,33,34,35,36,37,38,39};
worksheet.Cells.ImportArray(data, 0, 0,true);
// Creating a named range
Range range = worksheet.Cells.CreateRange("A1", "A10");

// Setting the name of the named range
range.Name = "aRange";

// Set the conditional format range.
Aspose.Cells.Range aRange = workbook.Worksheets.GetRangeByName("aRange");
CellArea ca = new CellArea();
ca.StartRow = aRange.FirstRow;
ca.EndRow = aRange.FirstRow + aRange.RowCount - 1;
ca.StartColumn = aRange.FirstColumn;
ca.EndColumn = aRange.FirstColumn + aRange.ColumnCount - 1;
fcs.AddArea(ca);

// Add conditions.
int conditionIndex = fcs.AddCondition(FormatConditionType.ColorScale, OperatorType.Between, "=Min(A1:A5)", "=MAX(A1:A5)");

conditionIndex = fcs.AddCondition(FormatConditionType.CellValue, OperatorType.Between, "30", "50");

// Change style on the second condition
FormatCondition fc = fcs[conditionIndex];
fc.Style.BackgroundColor = System.Drawing.Color.Red;

foreach(Cell cell in worksheet.Cells)
{
    Console.WriteLine($"{cell.GetDisplayStyle().ForegroundColor}");
}

workbook.Save("Output.xlsx");

For more details on conditional formatting visit the following document.
Conditional Formatting

Here you will find the latest version of this new product which can be freely downloaded for trials:
Aspose.Cells for .NET (Latest Version)

A detailed runnable solution is prepared which can be used to test the product features without writing any code. It can be downloaded here.