argh....hate copy-paste....(change all MSHFlexgrid1 to MSFlexgrid1 (my code uses MSHF....)

here:

For X = 0 To MSHFlexGrid1.Cols - 1
MSHFlexGrid1.Col = X
For Y = 1 To MSHFlexGrid1.Rows - 1
MSHFlexGrid1.Row = Y
MSHFlexGrid1.CellBackColor = vbYellow 'assuming vbYellow is original BG color
Next Y
Next X
For Z = 0 To MSHFlexGrid1.Cols - 1
MSHFlexGrid1.Col = Z
MSHFlexGrid1.Row = rownumber1
MSHFlexGrid1.CellBackColor = vbGreen
Next Z