MSHflexgrid row color.

[shukla]

Hi All!
I want a way by which i can color my entire row with only one command.
My problem is, i am displaying my flexgrid like an excel file.
ANd depending upon different crieteria, i want to color each row with some color.
I am using this code right now to color but it really takes time to color.
So is there any other way for the same ?

'j is my current row
For X = 0 To mygrid1.cols - 1
              .col = X
              .row = j
           mygrid.CellBackColor = cc
Next

[dee-u]

Can you try something like this?

With MSHFlexGrid1
    .Redraw = False
    ' set grid's style
    .AllowBigSelection = True
    .FillStyle = flexFillRepeat
    ' grey every other row
    .row = j
    .col = .FixedCols
    .ColSel = .Cols() - .FixedCols - 1
    .CellBackColor = cc
    .AllowBigSelection = False
    .FillStyle = flexFillSingle
    .Redraw = True
End With