- Code: Select all Expand view
- ADD COLUMN TO xBROWSE oBrw1 ;
SIZE 4 LEFT COLOR {||IF((gl->account >= "1500" .AND. gl->account <= "2040"),{RGB(0,0,0),RGB(128,0,0)},;
IF((gl->account >= "2055" .AND. gl->account <= "2500"),{RGB(0,0,0),RGB(0 , 0,128)},;
IF((gl->account >= "2520" .AND. gl->account <= "2625"),{RGB(0,0,0),RGB(0 ,128, 0)},;
IF((gl->account >= "2635" .AND. gl->account <= "2720"),{RGB(0,0,0),RGB(0 ,128,128)},;
IF((gl->account >= "2735" .AND. gl->account <= "2820"),{RGB(0,0,0),RGB(128,0 ,128)},;
IF((gl->account >= "2835" .AND. gl->account <= "2920"),{RGB(0,0,0),RGB(128,128, 0)},;
IF((gl->account >= "3000" .AND. gl->account <= "3353"),{RGB(0,0,0),RGB(0 , 0,255)},;
IF((gl->account >= "3360" .AND. gl->account <= "3480"),{RGB(0,0,0),RGB(255, 0,255)},;
IF((gl->account >= "3491" .AND. gl->account <= "3544"),{RGB(0,0,0),RGB(255,128, 0)},;
IF((gl->account >= "2935" .AND. gl->account <= "2996"),{RGB(0,0,0),RGB(0 ,255, 0)},;
{RGB(0,0,0),RGB(255,255,255)}))))))))))}
It colors a column based on the account number of the record. Refresh its gone.