Set or clear conditional formats.
Clear conditional formatting.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
Set conditional formatting.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Type |
Whether the conditional format compares the values of cells or contains a formula.
Specify one of the following values or an arbitrary value:
<blank>Cell ValueExpression
|
| Operator |
The operator to be used by a conditional format.
Specify one of the following values or an arbitrary value:
<blank>NoneBetweenEqualGreater thanGreater than or EqualLess thanLess than or EqualNot BetweenNot Equal
|
| Minimum | The first formula of the conditional format. |
| Maximum | The second formula of the conditional format. |
| BorderLeftStyle |
Excel LineStyle to use for left border.
Specify one of the following values or an arbitrary value:
<blank>ContinuousDashDashDotDashDotDotDotDoubleLineStyleNoneSlantDashDot
|
| BorderLeftWeight |
WeightNumber to use for left border.
Specify one of the following values or an arbitrary value:
<blank>HairlineMediumThickThin
|
| BorderLeftColorRGB (8.0) | Select a color to use for the left border color. BorderLeftColorRGB will be used if BorderLeftColor and BorderLeftColorRGB are both specified. |
| BorderLeftColor |
Excel color palette index to use for left border color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| BorderRightStyle |
Excel LineStyle to use for right border.
Specify one of the following values or an arbitrary value:
<blank>ContinuousDashDashDotDashDotDotDotDoubleLineStyleNoneSlantDashDot
|
| BorderRightWeight |
WeightNumber to use for right border.
Specify one of the following values or an arbitrary value:
<blank>HairlineMediumThickThin
|
| BorderRightColorRGB (8.0) | Select a color to use for the right border color. BorderRightColorRGB will be used if BorderRightColor and BorderRightColorRGB are both specified. |
| BorderRightColor |
Excel color palette index to use for right border color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| BorderTopStyle |
Excel LineStyle to use for top border.
Specify one of the following values or an arbitrary value:
<blank>ContinuousDashDashDotDashDotDotDotDoubleLineStyleNoneSlantDashDot
|
| BorderTopWeight |
WeightNumber to use for top border.
Specify one of the following values or an arbitrary value:
<blank>HairlineMediumThickThin
|
| BorderTopColorRGB (8.0) | Select a color to use for the top border color. BorderTopColorRGB will be used if BorderTopColor and BorderTopColorRGB are both specified. |
| BorderTopColor |
Excel color palette index to use for top border color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| BorderBottomStyle |
Excel LineStyle to use for bottom border.
Specify one of the following values or an arbitrary value:
<blank>ContinuousDashDashDotDashDotDotDotDoubleLineStyleNoneSlantDashDot
|
| BorderBottomWeight |
WeightNumber to use for bottom border.
Specify one of the following values or an arbitrary value:
<blank>HairlineMediumThickThin
|
| BorderBottomColorRGB (8.0) | Select a color to use for the bottom border color. BorderBottomColorRGB will be used if BorderBottomColor and BorderBottomColorRGB are both specified. |
| BorderBottomColor |
Excel color palette index to use for bottom border color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| FontName (Deprecated in: 8.0.0) | Font to apply. Setting the font name of a conditional format is not currently supported. |
| FontStyle |
Regular, Italic, Bold, or BoldItalic.
Specify one of the following values or an arbitrary value:
<blank>RegularItalicBoldBoldItalic
|
| FontSize (Deprecated in: 8.0.0) |
Font size to apply.
Specify one of the following values or an arbitrary value:
Setting the font size of a conditional format is not currently supported.
<blank>689101112141618202122242628364872
|
| FontUnderline |
None, Single, Double, SingelAccounting, DoubleAccounting.
Specify one of the following values or an arbitrary value:
<blank>SingleSingleAccountingDoubleDoubleAccountingNone
|
| FontColorRGB (8.0) | Select a color to use for the font color. FontColorRGB will be used if FontColor and FontColorRGB are both specified. |
| FontColor |
Excel color palette index to use for the Font color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| FontStrikeThrough |
Whether to apply Font strikethrough format.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| FillColorRGB (8.0) | Select a color to use for the fill color. FillColorRGB will be used if FillColor and FillColorRGB are both specified. |
| FillColor |
Excel color palette index to use for fill color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| PatternColorRGB (8.0) | Select a color to use for the pattern color. PatternColorRGB will be used if PatternColor and PatternColorRGB are both specified. |
| PatternColor |
Excel color palette index to use for pattern color. The value is zero-based from 0 to 55.
Specify one of the following values or an arbitrary value:
<blank>012345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455
|
| Pattern |
Pattern to use for fill.
Specify one of the following values or an arbitrary value:
<blank>AutomaticCheckerCrissCrossDownGray16Gray25Gray50Gray75Gray8GridHorizontalLightDownLightHorizontalLightUpLightVerticalNoneSemiGray75SolidUpVertical
|