SetOperator

Sets the comparison operator for the icon criterion.

Syntax

expression.SetOperator(operator);

expression - A variable that represents a ApiIconCriterion class.

Parameters

Name	Required/Optional	Data type	Default	Description
operator	Required	string		The operator to set ("xlGreaterEqual" or "xlGreater").

Returns

This method doesn't return any data.

Example

Set the comparison operator for an icon criterion in a spreadsheet.

// How do I set operator in a spreadsheet?

// Set operator using an icon criterion object in a spreadsheet.

const worksheet = Api.GetActiveSheet();
worksheet.GetRange('A1').SetValue('Results');
worksheet.GetRange('A2').SetValue(80);
worksheet.GetRange('A3').SetValue(55);
worksheet.GetRange('A4').SetValue(30);

const range = worksheet.GetRange('A2:A4');
const formatConditions = range.GetFormatConditions();
const iconCondition = formatConditions.AddIconSetCondition();
const criteria = iconCondition.GetIconCriteria();
const secondCriterion = criteria[1];

worksheet.GetRange('B1').SetValue('Operator before: ' + secondCriterion.GetOperator());
secondCriterion.SetOperator('xlGreater');
worksheet.GetRange('B2').SetValue('Operator after: ' + secondCriterion.GetOperator());