>If I have the following grid:
>
>a b c d e f (fields)
>___________
>1|5|3|2|2|4 (field values)
>1|5|3|2|2|4
>3|2|1|4|3|5
>
>and need to paint each different value with a different color as in:
>
>1 = blue
>2 = red
>3 = yellow
>4 = orange
>5 = green
>
>What command should I put on the init method of the grid? I've tried this:
>
>thisform.Grid1.SetAll("dynamicbackcolor","IIF(a=0,RGB(100,100,100),RGB(255,255,255))","column")
>
>But obviously, it affects the column backcolor of the whole grid depending on one field value.
>
>What should I do?
>
>Thanks in advance,
Gilberto, I'm not sure if I've understood your question, but you could try SPARSE = .T. instead of the default .F.
This tells the grid to act on each cell individually.
Barbara