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.