how to keep cell color of JMP table

guy_yosef

Hi,

I made a script that check last 30 days average and color in red if its above or bellow 1/3 of my limit

(assuming i keep my limit in 3 sigma it check for one sigma shift)

i can't save the color format into journal or XLS file, is there a way to share it with ppl that do not have JMP?

(I can't change zoom of JMP table so i can't even image capture it since its longer then one page...)

 

For( i = 1, i <= N Row( dt ), i++,

If( Column( dt, "Mean 30 days" )[i] > (((Column( dt, "Target" )[i])*2 + Column( dt, "Upper limit" )[i] )/3)

,Column( dt, "Mean 30 days" ) << Color Cells( 3,{i} )

)

);

For( i = 1, i <= N Row( dt ), i++,

If( Column( dt, "Mean 30 days" )[i] < (((Column( dt, "Target" )[i])*2 + Column( dt, "Low limit" )[i] )/3)

,Column( dt, "Mean 30 days" ) << Color Cells( 3,{i} )

)

);

txnelson

In JMP 12, the cell colors are copied to a journal;  Given your above  script, you can add:

new window("my journal",<<journal);

dt<<journal;

Here is the journal output for a simple example I ran: