How to use JSL to color local cells by value?

[#1]

For example, in the "weight" column of "Big class.jMP ", take the data in rows 1-10 and make the gradient color by data height, as in the Image.So can start and stop any color  want.

[#2]

• The same is true with other versions.

[#3 · Accepted solution]

What OS and JMP version(s) are you using?  I'm using JMP 14 on Windows 10, 64-bit.

Try these steps:

• Open Big Class
• Right click on height > Column Properties > Color Gradient

• Check "Color Cell by Value", then OK

• You should end up with this:

If this still doesn't work you'll need to contact the JMP helpdesk.

[#4]

Thank pmroz!

I did it.

[#5]

But  to do it manually in order to show this?

In addition, could  use JSL to automatically get the color number of each row cell in the column of "height"?

[#6]

A few years ago I asked the same question, 

Here it is: 

You basically have to extract it from the extracted script for the column you are interested in

[#7]

Thank Jim!
You have given me a lot of help and have made rapid progress.

I used to use VBA, and I was able to record most of the code for each step.
Now using JSL, also want to achieve fully automatic operation.

[#8]

• Recording each step of operation, VBA is relatively easy.

• 

[#9]

You can easily create a similar pattern in JSL.  But in JSL you create Functions.

[#10]

Thank Jim!

I still haven't learned to write "Functions".
I want to get a color number like this:

[#11]

Did you read the entry that I posted in my previous reply about how to retrieve Cell Colors?  It has a function that can provide you with how to access the cell colors.  If the colors have been set by the use of "Color or Mark by Column" then the only way I know to get the colors, is to create a rowstate column, copy the current rowstates to the new column, and then use the Color Of( Row State( row#)) to retrieve the color value.