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

Was this article helpful?

0 0
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook


Responses

  • Yolando
    How to use xltimeperiods?
    3 years ago

Post a comment