Highlight cells based on matched column names

Aam_jmp

I have a script that colors the minimum values yellow for every Studentized column in a table. I want to also highlight values adjacent to these values in raw columns. For example, for Studentized Resid Rest Pulse, the cell adjacent to -2.321144119 in Rest Pulse column i.e. 44. How can I do this in jsl? Can regex or match be helpful? Thank you  

dt = current data table();
col = dt << get column names( string );
nc = N Items( col );
For( i = 1, i <= nc, i++,
 Cols = Column(dt,i);
 If( Contains( col[i], "Studentized Resid" ),
 Min = dt << get rows where(as column(Cols)==(Col Min( Cols )));
 Cols << color cells(Yellow, Min);
 )
 );

 I am looking for something like this:

 

LinnerudExample.jmp

txnelson

I may not be understanding your issue.  If you want to color the cells adjecent to the min values found for the columns that contain "Studentized ....." then all you have to do is to do it.  You have the list of column names......colNamesList, and you are looking through the columns.  When you find a column that has "Studentized......" in it, you then find the name of the other column you want to color and the row that is the minimum value.  So that means, you also know the cells that are adjecent to the cells you are going to color.....

column(&nbsp;Substr( colNameList[i], 19 ) ) <<&nbsp;&nbsp;<< color cells( Yellow, MinRows )<BR />

and if you add this right after the coloring of the "Studentized......" column, it will  color the appropriate cell