Change value in datagridview cell

If DataGridView1.Item(columnindex,rowindex).Value = DataGridView1.Item(columnindex,rowindex).Value then
    DataGridView1.Item(columnindex,rowindex).Value = "Yes"
End if

where columnindex/rowindex are the indeces of the cell column/row starting from 0. To get the current column/row index, use

DataGridView1.CurrentCell.Columnindex
DataGridView1.CurrentCell.Rowindex

YOu can use CellEndEdit event of DataGridView to do this comparation, which is fired right after the cell is finished editing.

Goran

If DataGridView1.Item(columnindex,rowindex).Value = DataGridView2.Item(columnindex,rowindex).Value then
    DataGridView1.Item(columnindex,rowindex).Value = "Yes"
End if

I don't know what the row or column index will be. Could be row 10 in datagridview2 and row 3 in datagridview1. I will need to search Datagridview1 column 0 and find the match to Datagridview2 column zero and then update column seven from Datagridview1 where they match.

Unit               Date              Available
100               4/4/07            Yes
110               4/4/07            No      < Row to match>


Datagridview2

Unit              Name1                 Name2             Cleared
110              Smith                    Doe                 11:00               <Row to match with using 110>

Something like this maybe:

If Me.Datagridview1("unit").Value = Me.datagridview2.CurrentRow.Cells(1).Value Then
            Datagridview1.CurrentRow.Cells(7).Value = "Yes"
        End If

Error here
Me.Datagridview1("unit").