GridView - Making font bold conditionally

[yaksandcows]

I've just begun developing my first ASP .NET website using VWD2008 with VB.

I am querying an SQL database to fill a gridview. If the text displayed in a gridview cell = a certain value contained in another SQL table, i need the text to turn bold.

I have been experimenting with RowDataBound and RowCreated events, but to no avail.

Example of something i've tried:

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
Dim myLabel As Label = CType(e.Row.FindControl("lblTotalPoints"), Label)

If myLabel.Text = "1" Then
myLabel.Font.Bold = True
End If

End If
End Sub

Any help would be greatly appreciated.

[yaksandcows]

.................................................. .................................................. .......