BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
Highlighted
UberBock

Occasional Contributor

Joined:

Jan 11, 2019

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
txnelson

Super User

Joined:

Jun 22, 2012

Solution

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

Joined:

Jun 22, 2012

Solution

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

Joined:

Jan 11, 2019

Re: Selection and coloring cells

Thanks again!
pmroz

Super User

Joined:

Jun 23, 2011

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