topic Re: Color cells by specific condition in Discussions

Color cells by specific condition

LT — Fri, 29 Dec 2023 01:53:24 GMT

Hi,

I'm new for JSL.

I want the cell to change color based on specific condition.

for example, I want :dIGSS>5 get red color.

dt << Get Rows Where(:dIGSS>5);
:dIGSS << Color Cells(3);

But all dIGSS rows change to red.

I've found an example which can change cell's color based on specific condition, but it is for each column:

For Each({colname}, dt << Get Column Names("String"),
 rows_to_color = dt << Get Rows Where((Column(dt, colname)[]>5));
 Column(dt, colname) << Color Cells("Red", rows_to_color);
);

How can I do?

I have version 17.

Thanks.

Re: Color cells by specific condition

txnelson — Fri, 29 Dec 2023 03:46:04 GMT

Examining the issue, using the Scripting Index, there does not seem to be any "Color Cells" syntax that permits the coloring of cells for more than one column using JSL. There is a syntax for "Color Cells" that is used in conjunction with the Identifying of Outliers platform.

Therefore, the sample JSL you listed is the only method I know of to color the cells as you want.

Re: Color cells by specific condition

jthi — Tue, 09 Jan 2024 08:38:03 GMT

You can provide Color Cells with list of rows numbers (or matrix) and you can then use that (basically remove loop from your second example)

rows_to_color = dt << Get Rows Where(:dIGSS > 5));
:dIGSS << Color Cells("Red", rows_to_color);

See example 2 (and 3 if you need multiple colors) from Scripting Index for Color Cells

Edit:

Corrected text "You can provide Color Cells with list of columns" to "You can provide Color Cells with list of row numbers"

Re: Color cells by specific condition

LT — Tue, 02 Jan 2024 01:28:17 GMT

Thanks! This is exactly what I need.