How to change the BackColor of a DataGridView Cell if it contains invalid data

Question

0.00/5 (No votes)

See more:

I'm trying to find out if there is a way for me to change the backcolor of an individual datagridviewcell to red if the cell contains a certain value. For example:

VB

If (columnindex = 1) Then

        Dim cellData = DataGridView1.Rows(rowindex).Cells(columnindex).Value
        If cellData Is Nothing OrElse IsDBNull(cellData) OrElse cellData.ToString = String.Empty Then
            'Do nothing because this is allowed
            'Now I want to set the default backcolor for the datagridview to white
            DataGridView1.Rows(rowindex).Cells(columnindex).DefaultCellStyle.BackColor = Color.White
        ElseIf cellData < 0 Or cellData > 1 Then
            MessageBox.Show("Value Must be between 0 and 1")
            DataGridView1.Rows(rowindex).Cells(columnindex).Value = 0
            'This is where I'm hoping to make only the cells that values are not between 1 or zero have a backcolor of red
            DataGridView1.Rows(rowindex).Cells(columnindex).DefaultCellStyle.BackColor = Color.Red
            Exit Sub

        End If
    End If

as it currently stands my code will make the entire first column of the datagridview red if one ore more cells contain invalid data. I'm hoping for only the cells with the invalid data to be red. If anyone can figure this out I would greatly appreciate it! :)

Posted 24-Jul-13 8:54am

CAS1224

Add a Solution

Comments

CHill60 24-Jul-13 15:14pm

Try DataGridView1.Item(columnindex, rowindex).Style.BackColor = Color.Red

Maciej Los 24-Jul-13 16:09pm

My virtual 5!

CHill60 24-Jul-13 16:15pm

Thank you ... didn't post it as a solution as I haven't got any means of testing it at the moment. I thought it was right though and your (virtual) 5 confirms it :-)

CAS1224 24-Jul-13 16:19pm

For some reason its not working for me. I wonder if I'm doing something else wrong :\

Maciej Los 24-Jul-13 16:31pm

Have a look here: DataGridViewCell.Style Property [^]

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Winston Madiano · Accepted Answer · 2013-07-24T14:52:00

You can use DatagridviewCellFormating Event if you want to change the back color of you datagridview row based on cell value.

Ex:
On your DataGridView1_CellFormatting Event

VB

Dim row As DataGridViewRow = DataGridView1.Rows(e.RowIndex)
Dim obj As Object = row.Cells("ColumnName").Value
 If Not IsDBNull(row.Cells("ColumnName").Value) Then
  If row.Cells("ColumnName").Value < 0 Then
     row.DefaultCellStyle.BackColor = Color.Red

  ElseIf row.Cells("ColumnName").Value > 0 Then
     row.DefaultCellStyle.BackColor = Color.White
  End If
 End If

Return

How to change the BackColor of a DataGridView Cell if it contains invalid data

1 solution

Solution 1

Add your solution here

Preview 0

How to change the BackColor of a DataGridView Cell if it contains invalid data

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us