can we color the cells in jmp table as we do in excel? I mean really give colors to the part of table/cells interested

[#1]

can we color the cells in jmp table as we do in excel? I mean really give colors to the part of table/cells interested?

I tried below jsl but it only works when you plot the data in graphs but not in the table itself?

Thanks in advance!

Evan

dt=Data Table( "Bin Wafer Map" );
For(i=4, i<=N col(dt),i++,
dt:i << Set Property(
"Value Colors",
{1=Green,3 = Red, 4 = Yellow,5=orange, 6 = Magenta, 7 =Blue,8 = Cyan,9=BlueCyan}
));

[#2]

Hi! Found this topic is very helpful on my color cell function. However i have some concern. By using same table I only want to color cell values from columns 1 ~8 which contains > 0. Below code works on column 1 but I want to loop it through other columns 2~7. Can you help me on this? Thanks! 

dt = Data Table( "Bin Wafer Map" ); 
For( i = 1, i <= N Row( dt ), i++, 
If( Column( dt, "1" )[i] > 0, Column( dt, "1" ) << Color Cells( 4, {i} ), 
)
);

[#3]

I guess you need another loop to take care of the columns. Something like:

dt = Data Table( "Bin Wafer Map" );
// Loop over columns . . .
For(c = 1, c<=8, c++,
	// Loop over rows . . .
	For( i = 1, i <= N Row( dt ), i++,
		If( Column( dt, c )[i] > 0,
			Column( dt, c ) << Color Cells( 4, {i} ),

		)
	);
);

[#4]

Thanks a lot Ian! Nice work!