Examples/ConditionalFormatting/TextComparisons.ps1
|
try {Import-Module ..\..\ImportExcel.psd1 -Force} catch {throw ; return} $data = $( New-PSItem 100 @('test', 'testx') New-PSItem 200 New-PSItem 300 New-PSItem 400 New-PSItem 500 ) #Get rid of pre-exisiting sheet $xlSourcefile1 = "$env:TEMP\ImportExcelExample1.xlsx" $xlSourcefile2 = "$env:TEMP\ImportExcelExample2.xlsx" Write-Verbose -Verbose -Message "Save location: $xlSourcefile1" Write-Verbose -Verbose -Message "Save location: $xlSourcefile2" Remove-Item $xlSourcefile1 -ErrorAction Ignore Remove-Item $xlSourcefile2 -ErrorAction Ignore $data | Export-Excel $xlSourcefile1 -Show -ConditionalText $( New-ConditionalText -ConditionalType GreaterThan 300 New-ConditionalText -ConditionalType LessThan 300 -BackgroundColor cyan ) $data | Export-Excel $xlSourcefile2 -Show -ConditionalText $( New-ConditionalText -ConditionalType GreaterThanOrEqual 275 New-ConditionalText -ConditionalType LessThanOrEqual 250 -BackgroundColor cyan ) |