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} ) ) ) ;
... View more