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