BookmarkSubscribe
Choose Language Hide Translation Bar
Highlighted
UberBock
Occasional Contributor

Selection and coloring cells

So if I use:

dt = currentDataTable();
dt << select where(:RESULTNAME != "Success");
dt:RESULTNAME << color cells(RGB Color( 255, 150, 150 ));
dt << clear select();

 

When the data table has only 'Success' all cells are colored.  If the table has 1 value that is not 'Success' then it colors that cell and only that cell.  Anyway to have it not color all the cells when it only has 'Success'

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Selection and coloring cells

Try using this method

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");
dt<<select where(:age==12);

dt:age<<color cells("red", dt<<get selected rows);
Jim
3 REPLIES 3
txnelson
Super User

Re: Selection and coloring cells

Try using this method

names default to here(1);
dt=open("$SAMPLE_DATA/big class.jmp");
dt<<select where(:age==12);

dt:age<<color cells("red", dt<<get selected rows);
Jim
UberBock
Occasional Contributor

Re: Selection and coloring cells

Thanks again!
0 Kudos
pmroz
Super User

Re: Selection and coloring cells

You can also use get rows where:

dt = currentDataTable();
match_rows = dt << get rows where(:RESULTNAME != "Success");
dt:RESULTNAME << color cells(RGB Color( 255, 150, 150 ), match_rows);