Select Cell Color for Row Based on one Cell's Value

WendyLou315

Hello JMP Discussions.  I think this is an easy one but everything I have researched and everything I have tried has failed.

 

Is it possible to color all cells in a row based on the value found in a column of that row?  I want to select a color that is readable for selected row and leave ones that don't fit the criteria with default color.  If I use Color Rows by Row State the data is not readable using the default color scheme.  I need a table that will highlight the entire row when criteria is met.  Ex.  If Col_1 = 1 then color all of the cells in this row (Col_2, Col_3, Col_4, etc.) a light blue, otherwise, do nothing.

pmroz

You have to color cell by cell.  Try this code:

dt = New Table( "test", Add Rows( 6 ),
	New Column( "Column 1", Numeric, "Continuous", Format( "Best", 12 ),
		Set Values( [0, 1, 1, 0, 1, 0] ) ),
	New Column( "Column 2", Character, "Nominal",
		Set Values( {"A", "B", "C", "D", "E", "F"} ) ),
	New Column( "Column 3", Character, "Nominal", 
		Set Values( {"G", "H", "I", "J", "K", "L"} ) )
);

// Make the rows light gray
light_gray = rgb color(200, 200, 200);

my_rows = dt << get rows where(:Column 1 == 1);
my_row_list = as list(my_rows);
column_list = dt << get column names(String);
for (i = 1, i <= nitems(column_list), i++,
	column(dt, column_list[i]) << color cells(light_gray, my_row_list);
);