Other API Samples

Live SpreadsheetGear API Samples

Range Samples Conditional Formats Cell Value

Create a Cell Value Conditional Format.

// Create a new workbook and some local variables.
SpreadsheetGear.IWorkbook workbook = SpreadsheetGear.Factory.GetWorkbook();
SpreadsheetGear.IWorksheet worksheet = workbook.ActiveWorksheet;
SpreadsheetGear.IRange cells = worksheet.Cells;

// Add a title to a cell.
cells["A1"].Formula = "Cell Value";

// Get a reference to a range of cells.
SpreadsheetGear.IRange range = cells["A2:A11"];

// Load random data and format as $ using multiple cell range.
range.Formula = "=RAND() * 10000";
range.NumberFormat = "$#,##0_);($#,##0)";

// Get a reference to the range's conditional formats collection.
SpreadsheetGear.IFormatConditions conditions = range.FormatConditions;
// Add a conditional format for values less than or equal to 7000.
SpreadsheetGear.IFormatCondition condition = conditions.Add(
    SpreadsheetGear.FormatConditionOperator.LessEqual, "7000", null);

// Set font and interior formatting options.
condition.Font.Bold = false;
condition.Font.Color = SpreadsheetGear.Colors.White;
condition.Interior.Color = SpreadsheetGear.Colors.DarkSlateBlue;

// Add a conditional format for values greater than 7000.
condition = conditions.Add(
    SpreadsheetGear.FormatConditionOperator.Greater, "7000", null);

// Set font and interior formatting options.
condition.Font.Bold = true;
condition.Font.Italic = true;
condition.Font.Color = SpreadsheetGear.Colors.White;
condition.Interior.Color = SpreadsheetGear.Colors.Maroon;
Run This Sample
Render Image

Generate an image representation of the results of this sample, which uses the SpreadsheetGear.Drawing.Image class to convert ranges, charts and shapes to images.

Download File

Download an Excel Open XML Workbook (*.xlsx) file with the results of this sample.