Choose Language Hide Translation Bar
Von_Andre
Community Trekker

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

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} ), 
)
);
0 Kudos
ian_jmp
Staff

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

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} ),

		)
	);
);
Von_Andre
Community Trekker

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

Thanks a lot Ian! Nice work!
0 Kudos