Hi
i have searched again and this is some code that is working slighlty
Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound
If (e.Row.RowType = DataControlRowType.DataRow) Then
lblgrid = e.Row.FindControl("lblsiteUPRN")
lblgrid.Text = "X"
If lblgrid.Text Is vbNullString Then
End If
End If
End Sub
this created a new column call siteUPRN and puts an x when it is blank in siteUPRN however, i do not want to create another column, i need the orginal siteUPRN (that is autogenerated from the spreadsheet) to be the one that is searched for a null value and an x (or colour change) put in the empty cell