Using SQLDataSource To Populate Variable BoundField

I am using a SqlDataSource in my form page to query the DB and populate a GridView. If for example the value of Cell (3) is 
"1" I want to display the values of two other fields, Cells (6) & (7) in two ASP BoundFields 4 and 5. 

Then, When Cell(3) = "2"  I want to compare two Cells (8) & (9) procede as above, placing those values in ASP BoundFields 4 and 5.

Ive tried using the code below to do the comparisons of all the fields that I am using and then not displaying them with "Visible=False"
as I dont want all the fields to be visible... But this method has become quite cumbersome to manage.

Is there a better way to do this??

Thanks!

 

 Protected Sub TestStatus_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)


        If e.Row.RowType = DataControlRowType.DataRow Then
           
            If e.Row.Cells(3).Text = 1 Then

                e.Row.Cells(4).Text = "<font color=Green><b>" & e.Row.Cells(6).Text & "</b></font>"
                e.Row.Cells(5).Text = "<font color=Red><b>" & e.Row.Cells(7).Text & "</b></font>"

                e.Row.Cells(6).Visible = False
                e.Row.Cells(7).Visible = False
                e.Row.Cells(8).Visible = False
                e.Row.Cells(9).Visible = False

            End If

            If e.Row.Cells(3).Text = 2 Then

                e.Row.Cells(4).Text = "<font color=Orange><b>" & e.Row.Cells(8).Text & "</b></font>"
                e.Row.Cells(5).Text = "<font color=Blue><b>" & e.Row.Cells(9).Text & "</b></font>"

                e.Row.Cells(6).Visible = False
                e.Row.Cells(7).Visible = False
                e.Row.Cells(8).Visible = False
                e.Row.Cells(9).Visible = False

            End If
        End If
    End Sub