Thanks. Your UDF call idea did the trick.
>You may want to try like this
>
>oGrd.SetAll("dynamicbackcolor", ;
>"IIF(teacher selected for student ( your logic), RGB(255,0,0), RGB(255,255,255))", "Column")
>
>HTH
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.