Table formatting using a function

[andrewducker]

I have a column that contains a bunch of statuses that I want to colour differently depending on the contents. I already have a function that turns a status into a colour. I can't see any way of reusing that though. Should I just reimplement that as a set of TableConditionalFormatting statements? Not a big deal, just wondering if it was possible.

[PrzemyslawKlys]

I am not sure what you're really asking. TableConditionalFormatting is exactly for that?

[andrewducker]

Yeah, I figured there wasn't a way of controlling things in a finer-grained manner.

I think what I was thinking of was something like:

TableConditionalFormatting -Name 'Status'  -BackgroundColor { Get-StatusColour $_}

(Where Get-StatusColour returns "Green" for "Passed", etc, etc.)

But I've done it with the normal manner, and it's only added a few lines in.

[PrzemyslawKlys]

But you can use foreach inside it.... so just loop over your statuses adding a single line of table condition?

[andrewducker]

Aaah! Thank you, that cracked it.

function Get-TableFormattingForStatus {
	foreach($state in [enum]::GetValues([MyStateEnum])){
		TableConditionalFormatting -Name 'Status' -ComparisonType string -Operator eq -Value $state -Color White -BackgroundColor (Get-StateColour $state)
	}
}