hi all, how do you color the last row of msflexgrid? i have done a code which copies from one flexgrid to another, but my question is, how do you know that the one that you are coloring is the last 4 rows?

this is my code, copy a data to another flexgrid, but i want to color the last 4 rows.

Code:
Dim iRow As Integer

For iRow = 1 To MSFlexGrid1.Rows - 1

With MSFlexGrid2
    .AddItem .Rows
    .TextMatrix(.Rows - 1, 0) = MSFlexGrid1.TextMatrix(iRow, 0)
    .TextMatrix(.Rows - 1, 1) = MSFlexGrid1.TextMatrix(iRow, 1)
    .TextMatrix(.Rows - 1, 2) = MSFlexGrid1.TextMatrix(iRow, 2)
    .TextMatrix(.Rows - 1, 3) = MSFlexGrid1.TextMatrix(iRow, 3)
    .TextMatrix(.Rows - 1, 4) = MSFlexGrid1.TextMatrix(iRow, 4)
    .TextMatrix(.Rows - 1, 5) = MSFlexGrid1.TextMatrix(iRow, 5)
    .TextMatrix(.Rows - 1, 6) = MSFlexGrid1.TextMatrix(iRow, 6)
    .TextMatrix(.Rows - 1, 7) = MSFlexGrid1.TextMatrix(iRow, 7)
End With


Next
thanks for your help.