Dynamic Formatting

Dynamic Formatting allows to format the individual records of Lists and Certificates differently, for example men could be printed in blue and women in pink.

An Expression is used which generates a text with formatting instructions. This expression is entered for lists in the Extended Column Settings and for Certificates.

The formatting text can contain several instructions which are separated by semicolons:

Element1;Element2;...

These elements can be:

B

Bold
I Italic
U Underlined
S Strike-Through
AL Align Left
AC Align Center
AR Align Right
C(X) Font Color X
BG(X) Background Color X
T(X) Transparency level (0-100%) 

BTC(X) / BRC(X)

BBC(X) / BLC(X)

Border Top / Right / Bottom / Left Color X
BTW(X) / BRW(X)
BBW(X) / BLW(X)
Border Top / Right / Bottom / Left Width X
FS(X)* Font Size X in pt
OC(X)** Outline Text Color X
OW(X)** Outline Width X
Value 0-5 in 0.5 increments

* only applicable to outputs in PDF and certificates in Designer. For PDF outputs X must be smaller than the default font size. 
**only applicable to certificates in the Designer

Possible color values are:

See more information on colours HERE

Examples
A field will be printed italic for women:

 if([Sex]="f"; "I"; "")


A field is formatted with a red background and white text for participants with Age less than 18.

 

 if([Age]<18; "BG(#FF0000);C(#FFFFFF)"; "")


A field is marked red for participants from USA:

 

 

if([Nation.IOC]="USA"; "C(255,0,0)"; "")