Subscribe Bookmark RSS Feed

Can JMP do conditional format on tables in a journal?

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
this is an old question. anyone?
aim

Community Trekker

Joined:

Jun 23, 2011

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'">

 



ms

Super User

Joined:

Jun 23, 2011

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.
good idea to confert data to text and format them with condition. it works. .thanks a lot.