>Nadya,
>
>I've the column to change between two colours using
>
>IIF(LEVEL=1,RGB(0,0,255),RGB(128,255,128)
>
>but I want to do for this up to 5 colours based on the field "level" can i use a program to contain the CASE command?
>
>RC
>Bespoke Software System

Recently I switched to idea, showed by Dragan Nedeljkovich, and I like it.

Create a table called LevelGroup with 4 fields:
CodeVal Descript myForeClr I myBackClr I

Fill it with possible Level codes, and color combinations (numbers).

In the Init of your grid put:
this.setall('DynamicForeColor','LevelGroup.myForeClr') && If you want it for all columns

Set relation to LevelGroup. That's it. Works fast too.