Format Condition Properties

Name

Returns

Description

AppliesTo

Range

Read-only. Returns the range that is affected by the formatting rule

Borders

Borders

Read-only. Returns a collection holding all the individual border attributes for the formatting condition

Font

Font

Read-only. Returns an object containing Font options for the formatting condition

FormatRow

Boolean

Set/Get the Boolean value specifying if the entire Excel table row should be formatted. The default value is False

Formulai

String

Read-only. Returns the value that the cells must contain or an expression or formula evaluating to True/False. If the formula or expression evaluates to True, then the formatting is applied

Formula2

String

Read-only. Returns the value that the cells must contain or an expression evaluating to True/False. Valid only if the Operator property is xlBetween or xlNotBetween

Interior

Interior

Read-only. Returns an object containing options to format the inside area for the formatting condition (for example, interior color)

NumberFormat

Variant

Set/Get the number format applied to a cell if the conditional formatting rule evaluates to true

Name Returns Description

Condition

Operator

Read-only. Returns the operator to apply to the Formulal and Formula2 property. Use the xlFormatConditionOperator constants

Period

xlTimePeriods

Set/Get the time period used to apply the conditional formatting rule. Use one of the xlTimePeriods constants

Priority

Long

Set/Get the priority value of a conditional formatting rule, determining the order of evaluation when other rules are in effect

PTCondition

Boolean

Read-only. Indicates whether the formatting rule is applied to a PivotTable chart

Condition

Scope

Set/Get the scope of the formatting rule when applied to a PivotTable chart. Use the xlPivotConditionScope constants

StopifTrue

Boolean

Set/Get a Boolean value that determines if additional formatting rules should be applied if the current rule evaluates to True. The default value is True

Text

String

Set/Get text string used in the formatting rule

TextOperator

XlContains Operator

Set/Get an XlContainsOperator constant, specifying the text search performed by the formatting rule

Type

xlFormat ConditionType

Read-only. Returns an xlFormatConditionType constant, which specifies the type of conditional formatting being applied

0 0

Responses

  • Yolando
    How to use xltimeperiods?
    3 years ago

Post a comment