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,For every bug fixed, there is a bigger bug not yet discovered.
|