Skip to main content

Conditional Formatting

APIDescriptionExample
Range.FormatConditionsProperty that returns the conditional formatting management object for the specified rangelet range = instance.Application.ActiveSheet.Range("A1");

let formatConditions = range.FormatConditions;
FormatConditions.CountProperty that returns the number of conditional formatting ruleslet range = instance.Application.ActiveSheet.Range("A1");
let formatConditions = range.FormatConditions;

console.log(formatConditions.Count);
FormatConditions.AddFunction that adds conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;

formatConditions.Add({
Type: instance.Enums.XlFormatConditionType.xlCellValue,
Operator: instance.Enums.XlFormatConditionOperator.xlGreater,
Formula1: "=10"
});
FormatConditions.AddAboveAverageFunction that adds above average conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;

formatConditions.AddAboveAverage();
AboveAverage.AboveBelowProperty that returns or changes the condition to specify based on averagelet range = instance.Application.ActiveSheet.Range("A1:B2");
let aboveAverage = range.FormatConditions.AddAboveAverage();

console.log(aboveAverage.AboveBelow);
aboveAverage.AboveBelow = instance.Enums.XlAboveBelow.xlAboveAverage;
AboveAverage.AppliesToProperty that returns the target range object of the above average conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let aboveAverage = range.FormatConditions.AddAboveAverage();

let target = aboveAverage.AppliesTo;
AboveAverage.BordersProperty that returns the border management object for the above average conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let aboveAverage = range.FormatConditions.AddAboveAverage();

let borders = aboveAverage.Borders;
AboveAverage.FontProperty that returns the font management object for the above average conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let aboveAverage = range.FormatConditions.AddAboveAverage();

let font = aboveAverage.Font;
AboveAverage.InteriorProperty that returns the background color management object for the above average conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let aboveAverage = range.FormatConditions.AddAboveAverage();

let interior = aboveAverage.Interior;
AboveAverage.PriorityProperty that returns or changes the priority of the above average conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let aboveAverage = range.FormatConditions.AddAboveAverage();

console.log(aboveAverage.Priority); aboveAverage.Priority = 1;
AboveAverage.StopIfTrueProperty that returns or changes whether to continue evaluating additional conditional formatting when the above average conditional formatting meets the conditionlet range = instance.Application.ActiveSheet.Range("A1:B2");
let aboveAverage = range.FormatConditions.AddAboveAverage();

console.log(aboveAverage.StopIfTrue);
aboveAverage.StopIfTrue = true;
AboveAverage.TypeProperty that returns the type of the above average conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let aboveAverage = range.FormatConditions.AddAboveAverage();

console.log(aboveAverage.Type); // 12 corresponding to instance.Enums.XlFormatConditionType.xlAboveAverageCondition is output to console
AboveAverage.DeleteFunction that removes the above average conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let aboveAverage = range.FormatConditions.AddAboveAverage();

aboveAverage.Delete();
AboveAverage.ModifyAppliesToRangeFunction that changes the target range of the above average conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let aboveAverage = range.FormatConditions.AddAboveAverage();

let target = instance.Application.ActiveSheet.Range("B2");
aboveAverage.ModifyAppliesToRange(target);
AboveAverage.SetFirstPriorityFunction that changes the priority to highest so that the above average conditional formatting is evaluated before other conditionslet range = instance.Application.ActiveSheet.Range("A1:B2");
let aboveAverage = range.FormatConditions.AddAboveAverage();

aboveAverage.SetFirstPriority();
AboveAverage.SetLastPriorityFunction that changes the priority to lowest so that the above average conditional formatting is evaluated after all other conditionslet range = instance.Application.ActiveSheet.Range("A1:B2");
let aboveAverage = range.FormatConditions.AddAboveAverage();

aboveAverage.SetLastPriority();
FormatConditions.AddColorScaleFunction that adds color scale conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;

formatConditions.AddColorScale(1);
ColorScale.AppliesToProperty that returns the target range object of the color scale conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);

let target = colorScale.AppliesTo;
ColorScale.ColorScaleCriteriaProperty that returns the object that manages the criteria of the color scale conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);

let colorScaleCriteria = colorScale.ColorScaleCriteria;
ColorScaleCriteria.CountProperty that returns the number of criteria for the color scale conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);
let colorScaleCriteria = colorScale.ColorScaleCriteria;

console.log(colorScaleCriteria.Count);
ColorScaleCriteria.ItemFunction that returns the criteria object corresponding to a specific index of the color scale conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);
let colorScaleCriteria = colorScale.ColorScaleCriteria;

let colorScaleCriterion = colorScaleCriteria.Item(1);
ColorScaleCriterion.FormatColorProperty that returns the object that manages the criteria color corresponding to a specific index of the color scale conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);
let colorScaleCriterion = colorScale.ColorScaleCriteria.Item(1);

let formatColor = colorScaleCriterion.FormatColor;
FormatColor.ColorProperty that returns or changes the criteria color corresponding to a specific index of the conditional formatting
cf) RGB numeric values corresponding to colors must be used		function RGBToInteger(rgbText) {
const [r,g,b] = rgbText.match(/\d+/g).map(Number);
return r + g * 256 + b * 65536;
}

let range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);
let colorScaleCriterion = colorScale.ColorScaleCriteria.Item(1);
let formatColor = colorScaleCriterion.FormatColor;

console.log(formatColor.Color);
formatColor.Color = RGBToInteger("RGB(255,199,206)");
FormatColor.ColorIndexProperty that returns or changes the criteria color corresponding to a specific index of the conditional formatting using index methodlet range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);
let colorScaleCriterion = colorScale.ColorScaleCriteria.Item(1);
let formatColor = colorScaleCriterion.FormatColor;

console.log(formatColor.ColorIndex);
formatColor.ColorIndex = 1;
FormatColor.ThemeColorProperty that returns or changes the criteria theme color corresponding to a specific index of the conditional formatting using index methodlet range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);
let colorScaleCriterion = colorScale.ColorScaleCriteria.Item(1);
let formatColor = colorScaleCriterion.FormatColor;

console.log(formatColor.ThemeColor);
formatColor.ThemeColor = 1;
FormatColor.TintAndShadeProperty that returns or changes the criteria brightness corresponding to a specific index of the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);
let colorScaleCriterion = colorScale.ColorScaleCriteria.Item(1);
let formatColor = colorScaleCriterion.FormatColor;

console.log(formatColor.TintAndShade);
formatColor.TintAndShade = 0.3;
ColorScaleCriterion.IndexProperty that returns the index of the criteria corresponding to a specific index of the color scale conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);
let colorScaleCriterion = colorScale.ColorScaleCriteria.Item(1);

console.log(colorScaleCriterion.Index);
ColorScaleCriterion.TypeProperty that returns or changes the type of the criteria corresponding to a specific index of the color scale conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);
let colorScaleCriterion = colorScale.ColorScaleCriteria.Item(1);

console.log(colorScaleCriterion.Type);
colorScaleCriterion.Type = instance.Enums.XlConditionValueTypes.xlConditionValueHighestValue;
ColorScaleCriterion.ValueProperty that returns or changes the criteria value corresponding to a specific index of the color scale conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);
let colorScaleCriterion = colorScale.ColorScaleCriteria.Item(1);

console.log(colorScaleCriterion.Value);
colorScaleCriterion.Value = 5;
ColorScale.SetLastPriorityFunction that changes the priority to lowest so that the color scale conditional formatting is evaluated lastlet range = instance.Application.ActiveSheet.Range("A1:B2");
let colorScale = range.FormatConditions.AddColorScale(1);

colorScale.SetLastPriority();
FormatConditions.AddDatabarFunction that adds data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;

formatConditions.AddDatabar();
Databar.AppliesToProperty that returns the target range object of the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

let target = databar.AppliesTo;
Databar.AxisColorProperty that returns the object that manages the axis color of the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

let formatColor = databar.AxisColor;
Databar.AxisPositionProperty that returns or changes the axis position of the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

console.log(databar.AxisPosition);
databar.AxisPosition =
instance.Enums.XlDataBarAxisPosition.xlDataBarAxisAutomatic;
Databar.BarColorProperty that returns the object that manages the bar color of the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

let formatColor = databar.BarColor;
Databar.BarFillTypeProperty that returns or changes the bar background fill method of the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

console.log(databar.BarFillType);
databar.BarFillType = instance.Enums.XlDataBarFillType.xlDataBarFillSolid;
Databar.MaxPointProperty that returns the object that manages the longest bar of the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

let conditionValue = databar.MaxPoint;
ConditionValue.TypeProperty that returns the condition type of the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();
let conditionValue = databar.MaxPoint;

console.log(conditionValue.Type);
ConditionValue.ValueProperty that returns the condition value of the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();
let conditionValue = databar.MaxPoint;

console.log(conditionValue.Value);
ConditionValue.ModifyFunction that modifies the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();
let conditionValue = databar.MaxPoint;

conditionValue.Modify(instance.Enums.XlConditionValueTypes.xlConditionValuePercent, 30);
Databar.MinPointProperty that returns the object that manages the shortest bar of the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

let conditionValue = databar.MinPoint;
Databar.PriorityProperty that returns or changes the priority of the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

console.log(databar.Priority);
databar.Priority = 1;
Databar.StopIfTrueProperty that returns or changes whether to continue evaluating additional conditional formatting when the data bar conditional formatting meets the conditionlet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

console.log(databar.StopIfTrue);
databar.StopIfTrue = true;
Databar.TypeProperty that returns the type of the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

console.log(colorScale.Type); // 4 corresponding to instance.Enums.XlFormatConditionType.xlDatabar is output to console
Databar.DeleteFunction that removes the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

databar.Delete();
Databar.ModifyAppliesToRangeFunction that changes the target range of the data bar conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

let target = instance.Application.ActiveSheet.Range("B2");
databar.ModifyAppliesToRange(target);
Databar.SetFirstPriorityFunction that changes the priority to highest so that the data bar conditional formatting is evaluated before other conditionslet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

databar.SetFirstPriority();
Databar.SetLastPriorityFunction that changes the priority to lowest so that the data bar conditional formatting is evaluated after all other conditionslet range = instance.Application.ActiveSheet.Range("A1:B2");
let databar = range.FormatConditions.AddDatabar();

databar.SetLastPriority();
FormatConditions.AddIconSetConditionFunction that adds icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;

formatConditions.AddIconSetCondition();
IconSetCondition.AppliesToProperty that returns the target range object of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

let target = iconSetCondition.AppliesTo;
IconSetCondition.IconCriteriaProperty that returns the object that manages the criteria of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

let iconCriteria = iconSetCondition.IconCriteria;
IconCriteria.CountProperty that returns the number of criteria for the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();
let iconCriteria = iconSetCondition.IconCriteria;

console.log(iconCriteria.Count);
IconCriteria.ItemFunction that returns the criteria object corresponding to a specific index of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();
let iconCriteria = iconSetCondition.IconCriteria;

let iconCriterion = iconCriteria.Item(1);
IconCriterion.IconProperty that returns or changes the icon of the criteria corresponding to a specific index of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();
let iconCriterion = iconSetCondition.IconCriteria.Item(1);

console.log(iconCriterion.Icon);
iconCriterion.Icon = instance.Enums.XlIcon.xlIconGreenUpArrow;
IconCriterion.IndexProperty that returns the index of the criteria corresponding to a specific index of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();
let iconCriterion = iconSetCondition.IconCriteria.Item(1);

console.log(iconCriterion.Index);
IconCriterion.OperatorProperty that returns or changes the operation method of the criteria corresponding to a specific index of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();
let iconCriterion = iconSetCondition.IconCriteria.Item(1);

console.log(iconCriterion.Operator);
iconCriterion.Operator = instance.Enums.XlFormatConditionOperator.xlGreater;
IconCriterion.TypeProperty that returns or changes the type of the criteria corresponding to a specific index of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();
let iconCriterion = iconSetCondition.IconCriteria.Item(1);

console.log(iconCriterion.Type);
iconCriterion.Type = instance.Enums.XlConditionValueTypes.xlConditionValueNumber;
IconCriterion.ValueProperty that returns or changes the condition value of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();
let iconCriterion = iconSetCondition.IconCriteria.Item(1);

console.log(iconCriterion.Value);
iconCriterion.Value = 5;
IconSetCondition.IconSetProperty that returns the object that manages the icon set of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

let iconSet = iconSetCondition.IconSet;
IconSet.CountProperty that returns the number of icons in the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();
let iconSet = iconSetCondition.IconSet;

console.log(iconSet.Count);
IconSet.IDProperty that returns the icon type used in the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();
let iconSet = iconSetCondition.IconSet;

console.log(iconSet.ID);
IconSet.ItemFunction that returns the icon object corresponding to a specific index of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();
let iconSet = iconSetCondition.IconSet;

let icon = iconSet.Item(1);
Icon.IndexProperty that returns the index of the icon corresponding to a specific index of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();
let iconSet = iconSetCondition.IconSet;
let icon = iconSet.Item(1);

console.log(icon.Index);
IconSetCondition.PercentileValuesProperty that returns or changes whether the icon set conditional formatting follows percentile valueslet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

console.log(iconSetCondition.PercentileValues);
iconSetCondition.PercentileValues = true;
IconSetCondition.PriorityProperty that returns or changes the priority of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

console.log(iconSetCondition.Priority);
iconSetCondition.Priority = 1;
IconSetCondition.ReverseOrderProperty that returns or changes whether the icon order of the icon set conditional formatting is reversedlet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

console.log(iconSetCondition.ReverseOrder);
iconSetCondition.ReverseOrder = true;
IconSetCondition.ShowIconOnlyProperty that returns or changes whether to show only icons in the range where the icon set conditional formatting is appliedlet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

console.log(iconSetCondition.ShowIconOnly);
iconSetCondition.ShowIconOnly = true;
IconSetCondition.StopIfTrueProperty that returns or changes whether to continue evaluating additional conditional formatting when the icon set conditional formatting meets the conditionlet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

console.log(iconSetCondition.StopIfTrue);
iconSetCondition.StopIfTrue = true;
IconSetCondition.TypeProperty that returns the type of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

console.log(iconSetCondition.Type); // 6 corresponding to instance.Enums.XlFormatConditionType.xlIconSets is output to console
IconSetCondition.DeleteFunction that removes the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

iconSetCondition.Delete();
IconSetCondition.ModifyAppliesToRangeFunction that changes the target range of the icon set conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

let target = instance.Application.ActiveSheet.Range("B2");
iconSetCondition.ModifyAppliesToRange(target);
IconSetCondition.SetFirstPriorityFunction that changes the priority to highest so that the icon set conditional formatting is evaluated before other conditionslet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

iconSetCondition.SetFirstPriority();
IconSetCondition.SetLastPriorityFunction that changes the priority to lowest so that the icon set conditional formatting is evaluated after all other conditionslet range = instance.Application.ActiveSheet.Range("A1:B2");
let iconSetCondition = range.FormatConditions.AddIconSetCondition();

iconSetCondition.SetLastPriority();
FormatConditions.AddTop10Function that adds top 10 items conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;

formatConditions.AddTop10();
Top10.AppliesToProperty that returns the target range object of the top 10 items conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

let target = top10.AppliesTo;
Top10.BordersProperty that returns the border management object for the top 10 items conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

let border = top10.Borders;
Top10.FontProperty that returns the font management object for the top 10 items conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

let font = top10.Font;
Top10.InteriorProperty that returns the background color management object for the top 10 items conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

let interior = top10.Interior;
Top10.PercentProperty that returns or changes whether to set the ranking of the top 10 items conditional formatting based on percentage valueslet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

console.log(top10.Percent);
top10.Percent = true;
Top10.PriorityProperty that returns or changes the priority of the top 10 items conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

console.log(top10.Priority);
top10.Priority = 1;
Top10.RankProperty that returns or changes the criteria value for ranking the top 10 items conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

console.log(top10.Rank);
top10.Rank = 5;
Top10.StopIfTrueProperty that returns or changes whether to continue evaluating additional conditional formatting when the top 10 items conditional formatting meets the conditionlet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

console.log(top10.StopIfTrue);
top10.StopIfTrue = true;
Top10.TopBottomProperty that returns or changes whether the top 10 items conditional formatting applies to top items or bottom itemslet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

console.log(top10.TopBottom);
top10.TopBottom = instance.Enums.XlTopBottom.xlTop10Top;
Top10.TypeProperty that returns the type of the top 10 items conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

console.log(top10.Type); // 5 corresponding to instance.Enums.XlFormatConditionType.xlTop10 is output to console
Top10.DeleteFunction that removes the top 10 items conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

top10.Delete();
Top10.ModifyAppliesToRangeFunction that changes the target range of the top 10 items conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

let target = instance.Application.ActiveSheet.Range("B2");
top10.ModifyAppliesToRange(target);
Top10.SetFirstPriorityFunction that changes the priority to highest so that the top 10 items conditional formatting is evaluated before other conditionslet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

top10.SetFirstPriority();
Top10.SetLastPriorityFunction that changes the priority to lowest so that the top 10 items conditional formatting is evaluated after all other conditionslet range = instance.Application.ActiveSheet.Range("A1:B2");
let top10 = range.FormatConditions.AddTop10();

top10.SetLastPriority();
FormatConditions.AddUniqueValuesFunction that adds conditional formatting based on unique valueslet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;

formatConditions.AddUniqueValues();
UniqueValues.AppliesToProperty that returns the target range object of the conditional formatting based on unique valueslet range = instance.Application.ActiveSheet.Range("A1:B2");
let uniqueValues = range.FormatConditions.AddUniqueValues();

let target = uniqueValues.AppliesTo;
UniqueValues.BordersProperty that returns the border management object for the conditional formatting based on unique valueslet range = instance.Application.ActiveSheet.Range("A1:B2");
let uniqueValues = range.FormatConditions.AddUniqueValues();

let borders = uniqueValues.Borders;
UniqueValues.DupeUniqueProperty that returns or changes whether the criteria of the conditional formatting based on unique values is for unique values or duplicate valueslet range = instance.Application.ActiveSheet.Range("A1:B2");
let uniqueValues = range.FormatConditions.AddUniqueValues();

console.log(uniqueValues.DupeUnique);
uniqueValues.DupeUnique = instance.Enums.XlDupeUnique.xlDuplicate;
UniqueValues.FontProperty that returns the font management object for the conditional formatting based on unique valueslet range = instance.Application.ActiveSheet.Range("A1:B2");
let uniqueValues = range.FormatConditions.AddUniqueValues();

let font = uniqueValues.Font;
UniqueValues.InteriorProperty that returns the background color management object for the conditional formatting based on unique valueslet range = instance.Application.ActiveSheet.Range("A1:B2");
let uniqueValues = range.FormatConditions.AddUniqueValues();

let interior = uniqueValues.Font;
UniqueValues.PriorityProperty that returns or changes the priority of the conditional formatting based on unique valueslet range = instance.Application.ActiveSheet.Range("A1:B2");
let uniqueValues = range.FormatConditions.AddUniqueValues();

console.log(uniqueValues.Priority);
uniqueValues.Priority = 1;
UniqueValues.StopIfTrueProperty that returns or changes whether to continue evaluating additional conditional formatting when the conditional formatting based on unique values meets the conditionlet range = instance.Application.ActiveSheet.Range("A1:B2");
let uniqueValues = range.FormatConditions.AddUniqueValues();

console.log(uniqueValues.StopIfTrue);
uniqueValues.StopIfTrue = true;
UniqueValues.TypeProperty that returns the type of the conditional formatting based on unique valueslet range = instance.Application.ActiveSheet.Range("A1:B2");
let uniqueValues = range.FormatConditions.AddUniqueValues();

console.log(uniqueValues.Type); // 8 corresponding to instance.Enums.XlFormatConditionType.xlUniqueValues is output to console
UniqueValues.DeleteFunction that removes the conditional formatting based on unique valueslet range = instance.Application.ActiveSheet.Range("A1:B2");
let uniqueValues = range.FormatConditions.AddUniqueValues();

uniqueValues.Delete();
UniqueValues.ModifyAppliesToRangeFunction that changes the target range of the conditional formatting based on unique valueslet range = instance.Application.ActiveSheet.Range("A1:B2");
let uniqueValues = range.FormatConditions.AddUniqueValues();

let target = instance.Application.ActiveSheet.Range("B2");
uniqueValues.ModifyAppliesToRange(target);
UniqueValues.SetFirstPriorityFunction that changes the priority to highest so that the conditional formatting based on unique values is evaluated before other conditionslet range = instance.Application.ActiveSheet.Range("A1:B2");
let uniqueValues = range.FormatConditions.AddUniqueValues();

uniqueValues.SetFirstPriority();
UniqueValues.SetLastPriorityFunction that changes the priority to lowest so that the conditional formatting based on unique values is evaluated after all other conditionslet range = instance.Application.ActiveSheet.Range("A1:B2");
let uniqueValues = range.FormatConditions.AddUniqueValues();

uniqueValues.SetLastPriority();
FormatConditions.DeleteFunction that removes all conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;

formatConditions.Delete();
FormatConditions.ItemFunction that returns the conditional formatting object at a specific indexlet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;

let formatCondition = formatConditions.Item(1);
FormatCondition.AppliesToProperty that returns the target range object of the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

let target = formatCondition.AppliesTo;
FormatCondition.BordersProperty that returns the border object of the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

let borders = formatCondition.Borders;
FormatCondition.DateOperatorProperty that returns or changes the date operation method of the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

console.log(formatCondition.DateOperator);
formatCondition.DateOperator = instance.Enums.XlTimePeriods.xlToday;
FormatCondition.FontProperty that returns the font object of the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

let font = formatCondition.Font;
FormatCondition.Formula1Property that returns the first formula used for evaluating the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

console.log(formatCondition.Formula1);
FormatCondition.Formula2Property that returns the second formula used for evaluating the conditional formatting
cf) Works normally when the operation method of the conditional formatting (FormatCondition.Operator) corresponds to the following items
· instance.Enums.XlFormatConditionOperator.xlBetween
· instance.Enums.XlFormatConditionOperator.xlNotBetween		let range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

console.log(formatCondition.Formula2);
FormatCondition.InteriorProperty that returns the range background object of the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

let interior = formatCondition.Interior;
FormatCondition.NumberFormatProperty that returns or changes the display format specified for the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

console.log(formatCondition.NumberFormat);
formatCondition.NumberFormat = "General";
FormatCondition.OperatorProperty that returns the operation method of the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

console.log(formatCondition.Operator);
FormatCondition.PriorityProperty that returns or changes the priority of the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

console.log(formatCondition.Priority);
formatCondition.Priority = 1;
FormatCondition.StopIfTrueProperty that returns or changes whether to continue evaluating additional conditional formatting when the conditional formatting meets the conditionlet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

console.log(formatCondition.StopIfTrue);
formatCondition.StopIfTrue = true;
FormatCondition.TextProperty that returns or changes the string used in the condition of the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

console.log(formatCondition.Text);
formatCondition.Text = "10";
FormatCondition.TextOperatorProperty that returns or changes how the condition of the conditional formatting operates on stringslet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

console.log(formatCondition.TextOperator);
formatCondition.TextOperator = instance.Enums.XlContainsOperator.xlDoesNotContain;
FormatCondition.TypeProperty that returns the type of the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

console.log(formatCondition.Type);
FormatCondition.DeleteFunction that removes the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

formatCondition.Delete();
FormatCondition.ModifyFunction that modifies the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

formatCondition.Modify(instance.Enums.XlFormatConditionType.xlCellValue);
FormatCondition.ModifyAppliesToRangeFunction that changes the target range of the conditional formattinglet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

let target = instance.Application.ActiveSheet.Range("B2");
formatCondition.ModifyAppliesToRange(target);
FormatCondition.SetFirstPriorityFunction that changes the priority to highest so that the conditional formatting is evaluated before other conditionslet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

formatCondition.SetFirstPriority();
FormatCondition.SetLastPriorityFunction that changes the priority to lowest so that the conditional formatting is evaluated after all other conditionslet range = instance.Application.ActiveSheet.Range("A1:B2");
let formatConditions = range.FormatConditions;
let formatCondition = formatConditions.Item(1);

formatCondition.SetLastPriority();

Format Management , Font Style , Cell Background Color and Border , Text Alignment and Line Breaks , Custom Formatting , Format Rendering Overview