DataGridView RowPrePaint - Paint rows based on Cell value

Hi,

I have been doing this in the Datasource Changed sub of a datagrid. I am changing the background color based on the parents value. It shouldnt be hard to convert to what you are after.

Hope this helps

Private Sub dgvNodes_DataSourceChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles dgvNodes.DataSourceChanged
        ' This changes the colour of a row.
        ' Changes colours when new powersource is used and lightens the colours when they are down the tree from the parent
        Dim CurrentRow As DataGridViewRow
        Dim ParentCell As DataGridViewTextBoxCell
        Dim LightenedColour As Color
        SourceColourIndex = 0
        ' Loops through all the rows in the datagrid
        For Each CurrentRow In dgvNodes.Rows
            ParentCell = dgvNodes(clnNodeFeedsFrom.Index, CurrentRow.Index)
            ' If the current node has no parent then it is a power source
            If ParentCell.Value = "" Then
                ' Assign each cell in that row to one of the colours in the list
                CurrentRow.DefaultCellStyle.BackColor = SourceColourList(SourceColourIndex)
                ' Increment the colour index by one so no two consective rows have the same colour
                SourceColourIndex = SourceColourIndex + 1
                If SourceColourIndex > SourceColourList.Length - 1 Then
                    SourceColourIndex = 0
                End If
            Else
                ' The current row is not a power supply so find its parent and lighten the colour
                LightenedColour = Lighten(FindParentColour(ParentCell.Value))
                ' Assign each cell in that row to the new colour
                CurrentRow.DefaultCellStyle.BackColor = LightenedColour
            End If
        Next
    End Sub

Select allOpen in new window

Your example was very helpful.  I was able to make the code in my program work as I wanted.

Thank you !