You can use nested iif(), but it looks nasty. Better create a function:

Function ValueColor
lparameter nValue
local lnColor
  Do Case
    Case nValue=0
      lnColor=Rgb(255,255,0)
    Case nValue<0
      lnColor=Rgb(255,200,200)
    Case nValue<10
      lnColor=Rgb(255,100,100)
    Otherwise
      lnColor=Rgb(255,255,255)
  Endcase
return lnColor

yourgrid.SetAll('dynamicbackcolor','ValColor(yourtable.yourfield)','column')

>Hi all,
>
>Can you display more then 2 colors dynamically within a Grid. I'd like to color individual cells to one of 4 different colors depending on data in record. Setall allows only for 2.
>
>thanks in advance,
>
>Don