Excel.Interfaces.ConditionalFormatData interface
Warning
This API is now deprecated.
An interface describing the data returned by calling conditionalFormat.toJSON()
.
Properties
cell |
Returns the cell value conditional format properties if the current conditional format is a |
cell |
Returns the cell value conditional format properties if the current conditional format is a |
color |
Returns the color scale conditional format properties if the current conditional format is a |
color |
Returns the color scale conditional format properties if the current conditional format is a |
custom | Returns the custom conditional format properties if the current conditional format is a custom type. |
custom |
Returns the custom conditional format properties if the current conditional format is a custom type. |
data |
Returns the data bar properties if the current conditional format is a data bar. |
data |
Returns the data bar properties if the current conditional format is a data bar. |
icon |
Returns the icon set conditional format properties if the current conditional format is an |
icon |
Returns the icon set conditional format properties if the current conditional format is an |
id | The priority of the conditional format in the current |
preset | Returns the preset criteria conditional format. See |
preset |
Returns the preset criteria conditional format. See |
priority | The priority (or index) within the conditional format collection that this conditional format currently exists in. Changing this also changes other conditional formats' priorities, to allow for a contiguous priority order. Use a negative priority to begin from the back. Priorities greater than the bounds will get and set to the maximum (or minimum if negative) priority. Also note that if you change the priority, you have to re-fetch a new copy of the object at that new priority location if you want to make further changes to it. |
stop |
If the conditions of this conditional format are met, no lower-priority formats shall take effect on that cell. Value is |
text |
Returns the specific text conditional format properties if the current conditional format is a text type. For example, to format cells matching the word "Text". |
text |
Returns the specific text conditional format properties if the current conditional format is a text type. For example, to format cells matching the word "Text". |
top |
Returns the top/bottom conditional format properties if the current conditional format is a |
top |
Returns the top/bottom conditional format properties if the current conditional format is a |
type | A type of conditional format. Only one can be set at a time. |
Property Details
cellValue
Warning
This API is now deprecated.
Returns the cell value conditional format properties if the current conditional format is a CellValue
type.
cellValue?: Excel.Interfaces.CellValueConditionalFormatData;
Property Value
Remarks
cellValueOrNullObject
Returns the cell value conditional format properties if the current conditional format is a CellValue
type.
cellValueOrNullObject?: Excel.Interfaces.CellValueConditionalFormatData;
Property Value
Remarks
colorScale
Warning
This API is now deprecated.
Returns the color scale conditional format properties if the current conditional format is a ColorScale
type.
colorScale?: Excel.Interfaces.ColorScaleConditionalFormatData;
Property Value
Remarks
colorScaleOrNullObject
Warning
This API is now deprecated.
Returns the color scale conditional format properties if the current conditional format is a ColorScale
type.
colorScaleOrNullObject?: Excel.Interfaces.ColorScaleConditionalFormatData;
Property Value
Remarks
custom
Warning
This API is now deprecated.
Returns the custom conditional format properties if the current conditional format is a custom type.
custom?: Excel.Interfaces.CustomConditionalFormatData;
Property Value
Remarks
customOrNullObject
Warning
This API is now deprecated.
Returns the custom conditional format properties if the current conditional format is a custom type.
customOrNullObject?: Excel.Interfaces.CustomConditionalFormatData;
Property Value
Remarks
dataBar
Warning
This API is now deprecated.
Returns the data bar properties if the current conditional format is a data bar.
dataBar?: Excel.Interfaces.DataBarConditionalFormatData;
Property Value
Remarks
dataBarOrNullObject
Warning
This API is now deprecated.
Returns the data bar properties if the current conditional format is a data bar.
dataBarOrNullObject?: Excel.Interfaces.DataBarConditionalFormatData;
Property Value
Remarks
iconSet
Warning
This API is now deprecated.
Returns the icon set conditional format properties if the current conditional format is an IconSet
type.
iconSet?: Excel.Interfaces.IconSetConditionalFormatData;
Property Value
Remarks
iconSetOrNullObject
Warning
This API is now deprecated.
Returns the icon set conditional format properties if the current conditional format is an IconSet
type.
iconSetOrNullObject?: Excel.Interfaces.IconSetConditionalFormatData;
Property Value
Remarks
id
Warning
This API is now deprecated.
The priority of the conditional format in the current ConditionalFormatCollection
.
id?: string;
Property Value
string
Remarks
preset
Warning
This API is now deprecated.
Returns the preset criteria conditional format. See Excel.PresetCriteriaConditionalFormat
for more details.
preset?: Excel.Interfaces.PresetCriteriaConditionalFormatData;
Property Value
Remarks
presetOrNullObject
Warning
This API is now deprecated.
Returns the preset criteria conditional format. See Excel.PresetCriteriaConditionalFormat
for more details.
presetOrNullObject?: Excel.Interfaces.PresetCriteriaConditionalFormatData;
Property Value
Remarks
priority
Warning
This API is now deprecated.
The priority (or index) within the conditional format collection that this conditional format currently exists in. Changing this also changes other conditional formats' priorities, to allow for a contiguous priority order. Use a negative priority to begin from the back. Priorities greater than the bounds will get and set to the maximum (or minimum if negative) priority. Also note that if you change the priority, you have to re-fetch a new copy of the object at that new priority location if you want to make further changes to it.
priority?: number;
Property Value
number
Remarks
stopIfTrue
Warning
This API is now deprecated.
If the conditions of this conditional format are met, no lower-priority formats shall take effect on that cell. Value is null
on data bars, icon sets, and color scales as there's no concept of StopIfTrue
for these.
stopIfTrue?: boolean;
Property Value
boolean
Remarks
textComparison
Warning
This API is now deprecated.
Returns the specific text conditional format properties if the current conditional format is a text type. For example, to format cells matching the word "Text".
textComparison?: Excel.Interfaces.TextConditionalFormatData;
Property Value
Remarks
textComparisonOrNullObject
Warning
This API is now deprecated.
Returns the specific text conditional format properties if the current conditional format is a text type. For example, to format cells matching the word "Text".
textComparisonOrNullObject?: Excel.Interfaces.TextConditionalFormatData;
Property Value
Remarks
topBottom
Warning
This API is now deprecated.
Returns the top/bottom conditional format properties if the current conditional format is a TopBottom
type. For example, to format the top 10% or bottom 10 items.
topBottom?: Excel.Interfaces.TopBottomConditionalFormatData;
Property Value
Remarks
topBottomOrNullObject
Warning
This API is now deprecated.
Returns the top/bottom conditional format properties if the current conditional format is a TopBottom
type. For example, to format the top 10% or bottom 10 items.
topBottomOrNullObject?: Excel.Interfaces.TopBottomConditionalFormatData;
Property Value
Remarks
type
Warning
This API is now deprecated.
A type of conditional format. Only one can be set at a time.
type?: Excel.ConditionalFormatType | "Custom" | "DataBar" | "ColorScale" | "IconSet" | "TopBottom" | "PresetCriteria" | "ContainsText" | "CellValue";
Property Value
Excel.ConditionalFormatType | "Custom" | "DataBar" | "ColorScale" | "IconSet" | "TopBottom" | "PresetCriteria" | "ContainsText" | "CellValue"
Remarks
Office Add-ins