topic Re: Color by cell in Discussions

Color by cell

jearls11 — Fri, 09 Jun 2023 19:58:46 GMT

for each row(

Hi folks,

I want to colour my cells by value,

so if the row is <= 25 red, if > 25 and < 50 orange , if> 50 < 70 yellow.

and >75 green.

i am breaking it down to test first and when i run the first 2 arguments, the second condition changes all the rows to orange

For Each Row(
	If(
		:CDO 4 week Avg <= 25, dt:CDO 4 week Avg << color cells( "Red", Row() ),
		:CDO 4 week Avg > 25 <= 50,
			dt:CDO 4 week Avg << color cells( "orange", Row() )
	)
);

I cant understand why I am overwriting the condition and changing all cells colors to orange

Re: Color by cell

jthi — Wed, 06 Oct 2021 10:19:07 GMT

Second comparison seems wrong.

Try changing:

:CDO 4 week Avg > 25 <=50,

25 < :CDO 4 week Avg <=50,

Re: Color by cell

jearls11 — Wed, 06 Oct 2021 15:09:46 GMT

And is it possible to loop this for each column or do i have to make a for loop for each of the columns?

Re: Color by cell

txnelson — Wed, 06 Oct 2021 15:24:22 GMT

Here is a simple example of coloring cells across multiple columns, without having to process the cells row by row.

Names Default To Here( 1 );
// Open Data Table: Blood Pressure.jmp
// → Data Table( "Blood Pressure" )
dt = Open( "$SAMPLE_DATA/Blood Pressure.jmp" );

For( i = 3, i <= N Cols( dt ), i++,
	theRows = dt << get rows where( As Column( dt, i ) > 180 );
	Column( dt, i ) << color cells( "red", theRows );
);