API Reference
New-TableCondition
Creates a new table condition with specified parameters and styling options for pass and fail conditions.
Remarks
This function creates a new table condition with the specified parameters and allows customization of the styling options for both pass and fail conditions.
Examples
EXAMPLE 1
New-TableCondition -Name 'Policies_Go' -ComparisonType number -Operator le -Value 0.2 -Color SeaGreen -FailColor FireBrick
Uses a PowerShell numeric literal with a dot decimal separator.
EXAMPLE 2
New-TableCondition -Name 'Policies_Go' -ComparisonType number -Operator le -Value '0,2' -Color SeaGreen -FailColor FireBrick
Uses a quoted locale-formatted decimal string. Avoid bare -Value 0,2 because PowerShell treats it as an array.
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
New-TableCondition [-Alignment <left|center|right|justify>] [-BackgroundColor <String>] [-CaseSensitive] [-ChildRowFill <Parent|Both>] [-Color <String>] [-ComparisonType <number|string|bool|date>] [-DateTimeFormat <String>] [-Direction <rtl>] [-FailAlignment <left|center|right|justify>] [-FailBackgroundColor <String>] [-FailColor <String>] [-FailDirection <rtl>] [-FailFontFamily <String>] [-FailFontSize <Object>] [-FailFontStyle <normal|italic|oblique>] [-FailFontVariant <normal|small-caps>] [-FailFontWeight <normal>] [-FailTextDecoration <line-through|overline|underline>] [-FailTextTransform <uppercase|lowercase|capitalize>] [-FontFamily <String>] [-FontSize <Object>] [-FontStyle <normal|italic|oblique>] [-FontVariant <normal|small-caps>] [-FontWeight <normal>] [-HighlightHeaders <String[]>] [-Inline] -Name <String> [-Operator <lt>] [-ReverseCondition] [-Row] [-TextDecoration <line-through|overline|underline>] [-TextTransform <uppercase|lowercase|capitalize>] [-Value <Object>] [<CommonParameters>]
#
All Parameter SetsParameters
- Alignment String
- Specifies the alignment for pass conditions.
- Possible values:
left,center,right,justify - BackgroundColor String
- Specifies the background color for pass conditions.
- CaseSensitive SwitchParameter
- Switch parameter to indicate if the comparison should be case-sensitive.
- ChildRowFill String
- Child row fill for responsive lists
- Possible values:
Parent,Both - Color String
- Specifies the text color for pass conditions.
- ComparisonType String
- Specifies the type of comparison to be performed. Valid values are 'number', 'string', 'bool', or 'date'.
- Possible values:
number,string,bool,date - DateTimeFormat String
- Specifies the format for date and time comparisons.
- Direction String
- Specifies the text direction for pass conditions.
- Possible values:
rtl - FailAlignment String
- Specifies the alignment for fail conditions.
- Possible values:
left,center,right,justify - FailBackgroundColor String
- Specifies the background color for fail conditions.
- FailColor String
- Specifies the text color for fail conditions.
- FailDirection String
- Specifies the text direction for fail conditions.
- Possible values:
rtl - FailFontFamily String
- Specifies the font family for fail conditions.
- FailFontSize Object
- Specifies the font size for fail conditions.
- FailFontStyle String
- Specifies the font style for fail conditions.
- Possible values:
normal,italic,oblique - FailFontVariant String
- Specifies the font variant for fail conditions.
- Possible values:
normal,small-caps - FailFontWeight String
- Specifies the font weight for fail conditions.
- Possible values:
normal,bold,bolder,lighter,100,200,300,400,500,600,700,800,900 - FailTextDecoration String
- Specifies the text decoration for fail conditions.
- Possible values:
line-through,overline,underline - FailTextTransform String
- Specifies the text transformation for fail conditions.
- Possible values:
uppercase,lowercase,capitalize - FontFamily String
- Specifies the font family for pass conditions.
- FontSize Object
- Specifies the font size for pass conditions.
- FontStyle String
- Specifies the font style for pass conditions.
- Possible values:
normal,italic,oblique - FontVariant String
- Specifies the font variant for pass conditions.
- Possible values:
normal,small-caps - FontWeight String
- Specifies the font weight for pass conditions.
- Possible values:
normal,bold,bolder,lighter,100,200,300,400,500,600,700,800,900 - HighlightHeaders String[]
- Specifies an array of headers to highlight based on the condition.
- Inline SwitchParameter
- Switch parameter to indicate if the styling should be applied inline.
- Name String
- Specifies the name of the condition.
- Operator String
- Specifies the comparison operator to be used.
- Possible values:
lt,le,eq,ge,gt,ne,contains,like,notlike,notcontains,between,betweenInclusive,in,notin - ReverseCondition SwitchParameter
- Switch parameter to reverse the comparison logic.
- Row SwitchParameter
- Switch parameter to indicate if the styling should be applied to the entire row.
- TextDecoration String
- Specifies the text decoration for pass conditions.
- Possible values:
line-through,overline,underline - TextTransform String
- Specifies the text transformation for pass conditions.
- Possible values:
uppercase,lowercase,capitalize - Value Object
- Specifies the value to compare against. In PowerShell decimal literals use a dot, for example 0.2. If you want to pass locale-formatted text such as 0,2, quote it as a string. Bare 0,2 is parsed by PowerShell as an array containing 0 and 2 before PSWriteHTML receives it.