you should use multiple IIFs e.g. IIF(a=1,RGB(255,255,255),IIF(a=2,RGB(),IIF(a=3...)))) just don't forget to close all the brackets (g) Arnon > >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, 2 >55,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, > >