API Reference
Cmdlet
Add-OfficeExcelConditionalRule
Adds a conditional formatting rule to the current worksheet.
Remarks
Adds a conditional formatting rule to the current worksheet.
Examples
Highlight values greater than 100.
PS>
ExcelSheet 'Data' { Add-OfficeExcelConditionalRule -Range 'C2:C100' -Operator GreaterThan -Formula1 '100' }
Applies a conditional rule to column C.
Common Parameters
This command supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable.
For more information, see about_CommonParameters.
Syntax
Add-OfficeExcelConditionalRule [-EqualAverage] [-Formula1 <String>] [-Formula2 <String>] [-HeaderName <String>] [-HeaderRow <Int32>] [-IncludeHeader] [-Operator <LessThan>] [-PassThru] [-Percent] [-PivotTableName <String>] [-PivotWholeTable] [-Range <String>] [-Rank <UInt32>] [-RuleType <CellIs>] [-StandardDeviation <UInt32>] [-StopIfTrue] [-TableName <String>] [-Text <String>] [-TimePeriod <Today>] [<CommonParameters>]Parameter set:
ContextParameters
- EqualAverage SwitchParameter
- Include values equal to the average for average rules.
- Formula1 String
- Primary formula or value.
- Formula2 String
- Optional secondary formula or value.
- HeaderName String
- Header or table column name used to resolve the target range.
- HeaderRow Int32
- Worksheet header row used when resolving HeaderName without a table. Use 0 for the first row of the used range.
- IncludeHeader SwitchParameter
- Include the header cell in the resolved range.
- Operator ExcelConditionalFormattingOperator
- Conditional formatting operator.
- Possible values:
LessThan,LessThanOrEqual,Equal,NotEqual,GreaterThanOrEqual,GreaterThan,Between,NotBetween,ContainsText,NotContains,BeginsWith,EndsWith - PassThru SwitchParameter
- Emit the range after applying the rule.
- Percent SwitchParameter
- Treat top/bottom rank as a percent.
- PivotTableName String
- Pivot table name used to resolve the target range.
- PivotWholeTable SwitchParameter
- Use the full pivot output range instead of the default data body range.
- Range String
- A1 range to apply the rule to.
- Rank UInt32
- Rank used by top/bottom rules.
- RuleType OfficeExcelConditionalRuleType
- Rule type to author.
- Possible values:
CellIs,Expression,Formula,DuplicateValues,UniqueValues,Top,Top10,Bottom,Bottom10,AboveAverage,BelowAverage,ContainsText,NotContainsText,BeginsWith,EndsWith,ContainsBlanks,NotContainsBlanks,ContainsErrors,NotContainsErrors,TimePeriod - StandardDeviation UInt32
- Optional standard deviation threshold for average rules.
- StopIfTrue SwitchParameter
- Stop evaluating later rules when this rule is true.
- TableName String
- Optional table name for header-based range resolution.
- Text String
- Text used by text-matching rule types.
- TimePeriod ExcelConditionalTimePeriod
- Time period used by time-period rules.
- Possible values:
Today,Yesterday,Tomorrow,Last7Days,ThisMonth,LastMonth,NextMonth,ThisWeek,LastWeek,NextWeek
Add-OfficeExcelConditionalRule -Document <ExcelDocument> [-EqualAverage] [-Formula1 <String>] [-Formula2 <String>] [-HeaderName <String>] [-HeaderRow <Int32>] [-IncludeHeader] [-Operator <LessThan>] [-PassThru] [-Percent] [-PivotTableName <String>] [-PivotWholeTable] [-Range <String>] [-Rank <UInt32>] [-RuleType <CellIs>] [-Sheet <String>] [-SheetIndex <Int32>] [-StandardDeviation <UInt32>] [-StopIfTrue] [-TableName <String>] [-Text <String>] [-TimePeriod <Today>] [<CommonParameters>]Parameter set:
DocumentParameters
- Document ExcelDocument
- Workbook to operate on outside the DSL context.
- EqualAverage SwitchParameter
- Include values equal to the average for average rules.
- Formula1 String
- Primary formula or value.
- Formula2 String
- Optional secondary formula or value.
- HeaderName String
- Header or table column name used to resolve the target range.
- HeaderRow Int32
- Worksheet header row used when resolving HeaderName without a table. Use 0 for the first row of the used range.
- IncludeHeader SwitchParameter
- Include the header cell in the resolved range.
- Operator ExcelConditionalFormattingOperator
- Conditional formatting operator.
- Possible values:
LessThan,LessThanOrEqual,Equal,NotEqual,GreaterThanOrEqual,GreaterThan,Between,NotBetween,ContainsText,NotContains,BeginsWith,EndsWith - PassThru SwitchParameter
- Emit the range after applying the rule.
- Percent SwitchParameter
- Treat top/bottom rank as a percent.
- PivotTableName String
- Pivot table name used to resolve the target range.
- PivotWholeTable SwitchParameter
- Use the full pivot output range instead of the default data body range.
- Range String
- A1 range to apply the rule to.
- Rank UInt32
- Rank used by top/bottom rules.
- RuleType OfficeExcelConditionalRuleType
- Rule type to author.
- Possible values:
CellIs,Expression,Formula,DuplicateValues,UniqueValues,Top,Top10,Bottom,Bottom10,AboveAverage,BelowAverage,ContainsText,NotContainsText,BeginsWith,EndsWith,ContainsBlanks,NotContainsBlanks,ContainsErrors,NotContainsErrors,TimePeriod - Sheet String
- Worksheet name when using Document.
- SheetIndex Int32
- Worksheet index (0-based) when using Document.
- StandardDeviation UInt32
- Optional standard deviation threshold for average rules.
- StopIfTrue SwitchParameter
- Stop evaluating later rules when this rule is true.
- TableName String
- Optional table name for header-based range resolution.
- Text String
- Text used by text-matching rule types.
- TimePeriod ExcelConditionalTimePeriod
- Time period used by time-period rules.
- Possible values:
Today,Yesterday,Tomorrow,Last7Days,ThisMonth,LastMonth,NextMonth,ThisWeek,LastWeek,NextWeek