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,