Can JMP do conditional format on tables in a journal?

Question

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

unknown · Answer

good idea to confert data to text and format them with condition. it works. .thanks a lot.

ms · Answer

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.

aim · Answer

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: black; FONT-FAMILY: 'Courier New'">AddFormatRule style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Function style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> {dt style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> colName style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> rule} style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> {Default Local} style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Current Data Table style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Column style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> colName ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><< style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Set Property( style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"CondFormat" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Eval style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> rule ) ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">FormatTable style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Function style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> {dt} style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> {Default Local} style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-spacerun: yes"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Get info from data table to speed up processing style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Current Data Table style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> _NumCols style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N Cols style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> _NumRows style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N Rows style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Init the display box for formatted table style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> DBList style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Lineup Box style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N Col style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">N Cols style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt ) ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Spacing( style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">3 style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ) ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Make column header style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">For style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> _NumCols style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">++, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 2"> _colName style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Column style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><< style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Get Name style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 2"> DBList style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><< style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Append( style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Border Box style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">right style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">15 style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Text Box style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> _colName style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Set Font Style( style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Bold" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ) ) )) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Build Formatted table style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">For style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> jj style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> jj style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> _NumRows style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> jj style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">++, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 2"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">For style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> _NumCols style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">++, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-spacerun: yes"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 2"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//Parse conditional formatting rule style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 3"> condFormat style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Column style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><< style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Get Property( style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"CondFormat" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 3"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">If style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Is List style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> condFormat ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-spacerun: yes"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//<--if column has conditional formatting assigned style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 4"> rule style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"Column(ii)[jj]" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">|| style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> condFormat[ style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1 style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">] style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">|| style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"condFormat[2]" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 3"> style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-spacerun: yes"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//if no conditional formatting style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 4"> rule style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"2" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 3"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 3"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Choose style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Eval style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Parse style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> rule ) ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">+ style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1 style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 3"> style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//case 1 - format if false style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 4"> fnt_clr style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Try style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> condFormat[ style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">4 style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">][ style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1 style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">] style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"black" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 4"> fnt_stl style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Try style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> condFormat[ style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">4 style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">][ style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">2 style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">] style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"regular" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 3"> style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//case 2 - format if true style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 4"> fnt_clr style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Try style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> condFormat[ style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">3 style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">][ style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">1 style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">] style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"black" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 4"> fnt_stl style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Try style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> condFormat[ style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">3 style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">][ style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">2 style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">] style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"regular" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 3"> style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//case 3 - no formatting style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 4"> fnt_clr style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"black" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 4"> fnt_stl style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"regular" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 3"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 3"> DBList style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><< style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Append( style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">V Center Box style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Text Box style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Column style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> dt style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ii )[jj] style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Font Color( fnt_clr ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> Set Font Style( fnt_stl ) ) ) ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 2"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//output results style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="mso-tab-count: 1"> DBList style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">// style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//AddFormatRule ( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">// style="mso-spacerun: yes"> , //<--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"> , //<--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"> //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'">// style="mso-spacerun: yes"> {operator, value, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">// style="mso-spacerun: yes"> {format if true - Font color, Font Style} style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">// style="mso-spacerun: yes"> ,[{Format if false} optional]} style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">// style="mso-spacerun: yes"> > style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//) style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">///////////////////////////////////////////////////////////////////////////////////// style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">//here is how to use: style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Courier New'">// style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">dt style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: #0000dd; FONT-FAMILY: 'Courier New'">Open style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">( style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"$SAMPLE_DATA/Big Class.jmp" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">AddFormatRule( dt style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"sex" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> { style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"==" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"M" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> { style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"blue" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"regular" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">} style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> { style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">11 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"bold" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">}} style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">AddFormatRule( dt style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"weight" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> { style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">">" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'">99 style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> { style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"red" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">, style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: purple; FONT-FAMILY: 'Courier New'">"bold italic" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">}} style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">test style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">= style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> FormatTable( dt ) style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> 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'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">test style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'"><< style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> journal style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: 'Courier New'">; style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'"> style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier New'">