Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- JMP User Community
- :
- Discussions
- :
- Can JMP do conditional format on tables in a journal?
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content
Can JMP do conditional format on tables in a journal?
Feb 26, 2010 8:54 AM
(1667 views)
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
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content
Re: Can JMP do conditional format on tables in a journal?
this is an old question. anyone?
Community Trekker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content
Re: Can JMP do conditional format on tables in a journal?
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"> <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'">//
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'">
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"> <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'">//
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'">
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content
Re: Can JMP do conditional format on tables in a journal?
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.
Thanks, I think I can learn quite a few tricks from this script.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content
Re: Can JMP do conditional format on tables in a journal?
good idea to confert data to text and format them with condition. it works. .thanks a lot.