Hello Gilberto but how many more optional values will you have ? you can still use SETALL with the extended IIF statments Arnon > >Arnon, thanks for your reply, but I guess in my case what I need is a way >that I could paint the cells in a grid being its field count value >-fcount()- undefined; say, I might have 30 fields or I might have later 50 >fields (or cols), so I would need something more generic that could change >these properties as it reads the database that has been placed in the >grid. > >Gil > >>you should use multiple IIFs >>e.g. >> >>IIF(a=1,RGB(255,255,255),IIF(a=2,RGB(),IIF(a=3...)))) > > >>>a b c d e f ....n (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(25 5 >, >>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, >>> >>> > >