Choose Language Hide Translation Bar
Highlighted
UberBock
Level III

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'

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
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

View solution in original post

3 REPLIES 3
Highlighted
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

View solution in original post

Highlighted
UberBock
Level III

Re: Selection and coloring cells

Thanks again!
Highlighted
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);
Article Labels

    There are no labels assigned to this post.