New-ConditionalText.ps1

function New-ConditionalText {
    [CmdletBinding()]
    [Diagnostics.CodeAnalysis.SuppressMessageAttribute('PSUseShouldProcessForStateChangingFunctions', '',Justification='Does not change system State')]
    param(
        #[Parameter(Mandatory=$true)]
        [Alias('ConditionValue')]
        $Text,
        [Alias('ForeGroundColor')]
        $ConditionalTextColor=[System.Drawing.Color]::DarkRed,
        $BackgroundColor=[System.Drawing.Color]::LightPink,
        [String]$Range,
        [OfficeOpenXml.Style.ExcelFillStyle]$PatternType=[OfficeOpenXml.Style.ExcelFillStyle]::Solid,
        [ValidateSet(
            'LessThan',        'LessThanOrEqual',      'GreaterThan',    'GreaterThanOrEqual',
            'Equal',           'NotEqual',
            'Top',             'TopPercent',           'Bottom',         'BottomPercent',
            'ContainsText',    'NotContainsText',      'BeginsWith',     'EndsWith',
            'ContainsBlanks',  'NotContainsBlanks',    'ContainsErrors', 'NotContainsErrors',
            'DuplicateValues', 'UniqueValues',
            'Tomorrow',        'Today',                'Yesterday',      'Last7Days',
            'NextWeek',        'ThisWeek',             'LastWeek',
            'NextMonth',       'ThisMonth',            'LastMonth',
            'AboveAverage',    'AboveOrEqualAverage',  'BelowAverage',  'BelowOrEqualAverage',
            'Expression'
        )]
        [Alias('RuleType')]
        $ConditionalType='ContainsText'
    )

    $obj = [PSCustomObject]@{
        Text                 = $Text
        ConditionalTextColor = $ConditionalTextColor
        ConditionalType      = $ConditionalType
        PatternType          = $PatternType
        Range                = $Range
        BackgroundColor      = $BackgroundColor
    }

    $obj.pstypenames.Clear()
    $obj.pstypenames.Add("ConditionalText")
    $obj
}