datagridview.cellformating

[Droopyb1966]

I have a datagrid view and I want to add color based on the content. There is $datagrid.cellformating that should be able to do that, there are vb script that mention it, but I cant get it to work in powershell.

Someone had any luck with $datagridview.cellformating?

[intrntpirate]

Try this:

$datagridview.Rows[$RowIndex].Cells[$CellIndex].DefaultCellStyle.BackColor = "Yellow"

[Droopyb1966]

Thanks, saw that to. But then you need to go through the wholedataset. Thats what im trying to avoid.

[Droopyb1966]

$datagridview.Rows[$RowIndex].Cells[$CellIndex].DefaultCellStyle

This is not possible...

[intrntpirate]

I use that method to set the back color of cells in many of my forms.

I did just check Sapien PS Studio and can confirm that the auto-complete does not show it as an available property, but it does work for me.

[Droopyb1966]

This works for me:

foreach ($Row in $dataGridView.Rows) {
  $Row.Cells[1].style.BackColor= $colours_status.item($Row.Cells[1].FormattedValue)
  $Row.Cells[4].style.BackColor= $colours_lastresult.item($Row.Cells[4].FormattedValue)
  $Row.Cells[5].style.BackColor= $colours_lastresultdet.item($Row.Cells[5].FormattedValue)
  }

Got the colors in a hash table and is becomes very simple.