topic Re: Selection and coloring cells in Discussions

Selection and coloring cells

UberBock — Mon, 11 Mar 2019 19:32:21 GMT

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'

Re: Selection and coloring cells

txnelson — Mon, 11 Mar 2019 17:00:19 GMT

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);

Re: Selection and coloring cells

UberBock — Mon, 11 Mar 2019 17:11:12 GMT

Thanks again!

Re: Selection and coloring cells

pmroz — Mon, 11 Mar 2019 22:48:12 GMT

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);