Can JMP do conditional format on tables in a journal? Actually, I have a journal with data summary table and I need to hightlight those numbers that fulfil my criteria. thanks
Here is a workaround: this is a script, which can take any data table, apply simple conditional formatting and output formatted table on the screen/into the journal.Not quite Excel-like, but at least something...
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">// style="mso-spacerun: yes"> <reference to data table>, //<--point to a table style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">// style="mso-spacerun: yes"> <string - column_name>, //<--indicate column name, to which conditional formatting needs to be added style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">// style="mso-spacerun: yes"> <rule style="mso-spacerun: yes"> //has to be a list, see examples of use below style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//New Window( "Table with Conditional Formatting", test ); //<--show in the new window, or in journal: style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">
Wow! Nice solution and it works perfectly. I tried to address this problem by looping through table cells directly in the Journal, to virtually no avail.
Thanks, I think I can learn quite a few tricks from this script.