Differentiate color in Matrix (Depends on value)

casanova

hi all,
I Have modified from nav standard matrix page
all can show correctly...
i want to differentiate the color in matrix page

I create this function

SetStyle(TextString : Text[20]) : Text[20]
IF TextString = 'Pending' THEN
   EXIT('Unfavorable')
ELSE IF TextString = 'InProgress' THEN
   EXIT('Favorable')
   ELSE
   EXIT('Ambiguous');

and then in AfterGetRecord

MATRIX_OnAfterGetRecord(ColumnID : Integer)
MATRIX_CellData[ColumnID] := '';
******
Filtering
******
IF Record.FINDSET THEN
  BEGIN
    MATRIX_CellData[ColumnID] := FORMAT(Record."Request Status");
    StyleText := SetStyle(MATRIX_CellData[ColumnID]);
    SetVisible;
END;

the color correctly changed..
but if 1 line consist of more than 1 value
then it will use the last one value

Example :
Status 1 = Blue
Status 2 = Green
Status 3 = Red

once in the same line have value like this
Status 1 Status 1 Status 1 Status 2
==> it will be green all
it should be Status 1 is blue and status 2 is green

any help how to solve it?
thanks