>>>I had an IIF statement in the dynamicBackcolor property of a grid that wasn't working correctly. So I started to try and figure out what was wrong and then realized I can't get the DynamicBackColor to work at all for me. I must be doing something wrong...I have ="rgb(255,0,0)". I've tried it with and without the quotes.
>>
>>DynamicBackColor usually includes IIF function, e.g.:
>>**** Grid.Init event
>>cLine1="IIF(recno="+this.tag+",16711680,8421376)"
>>this.SetAll("DynamicBackColor",cLine1,"Column")
>
>Hi Edward,
>
>I put the following line in the grid's init event:
>
>cLine1="IIF(schedule.sch_absent = .t., rgb(255,0,0), rgb(0,255,0))"
>this.SetAll("DynamicBackColor",cLine1,"Column4")
>
>But the column's BackColor is still white do you see anything else that I am doing wrong?
>
>Paul

For column4 only use:
This.Column4.Dynamicbackcolor="IIF(schedule.sch_absent=.t.,255,65280)"