topic Re: How can set different cells to different colors in Discussions

How can set different cells to different colors

lala — Wed, 26 Jul 2023 07:30:19 GMT

dt=Open("$SAMPLE_DATA/Big Class.jmp");

dt[1,1] is set to red
dt[1,2] is set to white
dt[1,1] is set to clear coloring

Thanks!

Re: How can set different cells to different colors

jthi — Wed, 26 Jul 2023 07:34:39 GMT

Use Color Cells

Scripting Index

Re: How can set different cells to different colors

pmroz — Wed, 26 Jul 2023 15:31:10 GMT

One to do this is to set the colors of cells in your table manually. Then look at the table script. Right click on the red triangle next to the table name and select Copy table script:

Here's the resulting code:

New Table( "Untitled 26", Add Rows( 3 ),
	New Column( "Column 1", Numeric, "Continuous",
		Format( "Best", 12 ),
		Color Cells( {{73, {1}}, {74, {2}}} ),
		Set Values( [1, 2, 3] )
	),
	New Column( "Column 2", Character, "Nominal",
		Color Cells( {{75, {2}}, {67, {3}}} ),
		Set Values( {"a", "b", "c"} )
	)
)